Raganath :

Do U have ORA -7445 in alert log ot any trace file
generated - if yes then it time to apply Patch Set
8.1.6.3 or rather upgrade to 8.1.7 'cause Oracle
is desupporting 8.1.6 since 31 October 2001

HTHU

Ankur Shah
Oracle DBA
DHR-GA

----- Original Message -----
From: "Ranganath K" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, August 30, 2001 9:32 AM
Subject: ora - 4031 while inserting into a parent table


> 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
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page