ORA-04031: shared pool buffer

From: Martin Terpstra <terpstra_at_ats.nld.alcatel.nl>
Date: Fri, 05 Mar 1999 16:06:47 +0100
Message-ID: <36DFF306.F117405C@ats.nld.alcatel.nl>

hello,

I got the following problem:

ORA-04031:
     unable to allocate 64528 bytes of shared memory

Oracle says about this message:

04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\")"

// *Cause:  More shared memory is needed than was allocated in the shared


//          pool.


// *Action: 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 parameter "shared_pool_size".




What I like to know is the following. Besides increasing the amount
of the shared_pool_size value (what is big enough ?),

1. what can I do at the moment the problem occurs to make it go away ? 2. what can I do to prevent this problem ?

thanks

--

Martin Terpstra                     Alcatel Telecom Nederland
Software Design Engineer            Engineering & Development
phone :  +31 (0)70 307-9407         Burgemeester Elsenlaan 170
fax   :  +31 (0)70 307-9191         2288 BH  RIJSWIJK

mailto:Martin.Terpstra_at_alcatel.nl NETHERLANDS Received on Fri Mar 05 1999 - 09:06:47 CST