Re: High shared pool usage

Hello Ram!

What is allocating the memory in the shared pool?

SELECT *
FROM   V$SGASTAT
WHERE pool='shared pool' ORDER BY bytes DESC;

If allocations for  "KGH: NO ACCESS" are very high, you are seeing an ASMM bug.

If "sql area" is very high, check if the same SQL is parsed again and
again and thus lots of child cursors exists for the same SQL (another
bug available in 10.2):


SELECT sql_id,count(*) childcount
FROM V_$SQL_SHARED_CURSOR
group by sql_id
order by childcount desc;

HTH,
Marcus
--
http://www.freelists.org/webpage/oracle-l


Other related posts: