Re: Shared memory problem on Oracle 7.2.2

In article <30EB9F89.5A83_at_stavanger.Geco-Prakla.slb.com>, peres_at_stavanger.Geco-Prakla.slb.com says...
>
>We are quite frequently getting error 4031 from
>our Oracle 7.2.2 database:
>
>GST0K1 > oerr ora 4031
>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".
>
>

AFAIK there is at least one bug (#318582) in 7.2 that leads to an ORA-4031. The shared pool is filled up with statements because the space is not freed correctly. This bug should be fixed in 7.2.3. I don't know if patches are available.

Hope this helps

-- 
    _/_/_/   _/_/_/ _/    _/  // Reinhard Kuhn             /  It can be      
   _/    _/ _/     _/  _/    //         (kuhn_at_cas-ps.com) /  done quickly,   
  _/_/_/   _/_/_/ _/_/      // CAS GmbH                  /  cheaply or well  
 _/  _/   _/     _/  _/    // Lemberger Strasse 14      /   - pick any two!  
_/   _/  _/_/_/ _/    _/  // 66955 Pirmasens, Germany  /