what is valid statement about the above scenario?

a.        Tune the number of latches by setting it to db_cache_size(50*db_block_size)
b.        Tune the number of latches by setting to large_pool_size/1000
c.        Tune the number of latches by setting it to Number of CPUs *1 *2
d.        Oracle9i would automatically calculate the number of latches required, based on the environment defined by the initialization parameters for the database and the operating system level parameters

Consider the following SQL statement:

SELECT         manufacturer_id, COUNT(*), order_date
FROM            ITEM
WHERE         price > 14.00
GROUP BY    order_date, manufacturer_id
HAVING        COUNT(*) > 10

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.