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;
Also look in the v$sgastat for the free memory and
v$shared_pool_reserved for statistics of the shared
pool reserved.
Finally if it isn't get solved, call Oracle support
because there are bugs asociated with 4031 errors.
Regards.
- Ranganath K <ranganathk_at_subexgroup.com> wrote:
> 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 increased the
> shared_pool_size from 15mb to 30mb
> and shared_pool_reserved_size from 1mb to 5mb but it
> didn't solve the
> problem. I also set the _db_cached_cursors
> parameter to 0 and bounced the
> database but in vain. BTW I am using oracle 8.1.6
> enterprise edition on Sun
> Solaris 2.7. Any help in this regard will be very
> much appreciated.
>
> TIA and Regards,
>
> Ranganath
>
>
> DISCLAIMER: This correspondence is confidential and
> intended for the named
> recipient(s) only. If you are not the named
> recipient and receive this
> correspondence in error, you must not copy,
> distribute or take any action in
> reliance on it and you should delete it from your
> system and notify the
> sender immediately. Unless otherwise stated, any
> views or opinions expressed
> are solely those of the author and do not represent
> those of Subex Systems
> Limited.
>
> www.subexgroup.com
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ranganath K
> INET: ranganathk_at_subexgroup.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Aug 31 2001 - 04:36:41 CDT
