We had this error on our database but we were doing a massive batch
processing when the shared_pool got fragmented and gave ORA-04031. because
it was unable to allocate a continuous chunk of memory. We were also on
8.1.6 on WinNT. Seemed like we had hit a bug of Oracle 8.1.6 because we
upgraded to 8.1.7.0.0 and with no other change we havn't got this problem
yet.

The thing I don't understand though is that by restarting the database you
shouldn't have got this problem so soon. It occurs only after sometime
meaning enough transactions have been done on database to cause it
fragmentation.

Anyway just my inputs. Hope helps you identify your problem
Ameet


----- Original Message -----
From: "Ranganath K" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, August 30, 2001 6: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


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Oracle LazyDBA home page