KQLs heap is part of dictionary cache. However since
8.0.X it is allocated in the library cache. Therefore
you should insist with increasing shared pool and
monitoring the amount needed for that heap from
v$subcache:
select name,heap_sz,heap_aloc,heap_used from
v$subcache
where heap_num=10;
Why is your shared pool so tiny?
-Original Message-
Sent: Thursday, August 30, 2001 10:37 AM
To: Multiple recipients of list ORACLE-L
Dear DBA Gurus,
I am getting the following error while inserting into a schema's parent
table which is being referred by 42 tables of another schema.
Raganath,
Sounds like you got some bad SQL operating. Usually the error you are
seeing is caused not by the shared pool being too small (although if it's
too small for you're trying to do, nothing will help), but rather by
excessive fragmentation making the requisite amount of continuous free