Re: Is this serious?

Also it would be >> serious << to upgrade to at least last 8i version !

Jason Baugher a écrit :

> "Tom" <tomNOSPAM_at_eazyriders.com> wrote in comp.databases.oracle.server:
>
> > ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> > pool","DBMS_LOB","PL/SQL MPCODE","BAMIMA: Bam Buffer")
> >
>
> Not sure about the rest, but this error is fairly self-explanatory...
>
> 04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s
> \",\"%s\",\"%s\")"
> // *Cause: More shared memory is needed than was allocated in the shared
> // pool.
> // *Action: If the shared pool is out of memory, either use the
> // dbms_shared_pool package to pin large packages,
> // reduce your use of shared memory, or increase the amount of
> // available shared memory by increasing the value of the
> // INIT.ORA parameters "shared_pool_reserved_size" and
> // "shared_pool_size".
> // If the large pool is out of memory, increase the INIT.ORA
> // parameter "large_pool_size".
>
> In your case, it specified shared pool, so you'd probably need to
> increase shared_pool_size and shared_pool_reserved_size in your init.ora.
>
> --
> Jason Baugher
> Virtual Adept Professional Consulting Services
> 1406 Adams Street, Quincy, IL 62301 - (217) 221-5406
> jason@baugher.pike.il.us - http://baugher.pike.il.us/virtualadept
Received on Tue Sep 03 2002 - 14:57:39 CDT