When we ran a script for shared pool utilization, here is the result we got. Anything that we should be troubled about? We are on Oracle 18.104.22.168. Our shared pool is 900MB and we run Oracle Applications 11.0.3.
900 MB Shared POOL Size is too big. Do you really need 900MB unless you have more than 100,000 tables and 1M columns?
03-01-2001, 12:13 PM
Do u see any high shared pool sleeps enteries in v$latch.
If yes , ur shared_pool_size could be very high.
03-01-2001, 01:45 PM
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.