Re: ORA-04031: unable to allocate 8192 bytes of shared memory

cat54me wrote:
> Hi all,
> I am running Oracle 9i R1 64-bit on Solaris 8 SPARC.
>
> I have a few web applications (Tomcat and ColdFusion MX) on another
> server connecting to the Oracle databases.
>
> Sometimes I get the following error when running an SQL query from a web
> application:
> "ORA-04031: unable to allocate 8192 bytes of shared memory"
>
> What is the cause? How do I fix it?
>
> Thanks in advance!

oerr ora 4031:
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".