Hi,
Check V$SGASTAT for free memory. If you are having lot of free memory all the time then your memory allocation is high. In that case you should look at tuning the latches. Beyond a certain limit, increasing shared pool will have negative impact on database operation.
Baliga




Reply With Quote