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;
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.
ORA-04031: unable to allocate 2196 bytes of shared memory (shared
pool,RA_VOLUME_PLAN_POOL,KQLS heap,KQLS MEM BLOCK);
How do I resolve this? I
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.
:
Sent by:Subject: ora - 4031 while inserting
into a parent table
[EMAIL PROTECTED