Re: Is this serious?

"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