Re: High shared pool usage

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