ora - 4031 while inserting into a parent table

From: Ranganath K <ranganathk_at_subexgroup.com>
Date: Thu, 30 Aug 2001 06:38:32 -0700
Message-ID: <F001.0037CE12.20010830063728@fatcity.com>

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). Received on Thu Aug 30 2001 - 08:38:32 CDT