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 -- //www.freelists.org/webpage/oracle-l