Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


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
15 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...