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

Hello Dirk,

• Check the free memory in shared_pool.
• "alter system flush shared_pool;" will work, shut/start is not needed.

Met vriendelijke groeten,

      Roelof Schierbeek

R. Schierbeek, Bytelife BV
email : info_at_bytelife.com
www : www.bytelife.com

Dirk Versavel <dirk.versavel_at_smartlounge.be> schreef in berichtnieuws..
> Dear,
> Since some time (since the database is more intensively used), the
> database stops responding about once a week. A database restart is
> necessary.
>
> The error is:
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","BEGIN :p := CTX_QUERY.PREFER...","PL/SQL MPCODE","BAMIMA: Bam
> Buffer")
>
> I tried to raise the "shared_pool_size" in the init.ora file but it
> does not seem te help much!
>
> The database is used by a number of J2EE based web applications using
> the oracle type 4 JDBC driver (classes12.zip). Could there be a
> 'memory leak' in the driver of in the client application causing these
> memory problem?
>
> We are also using intermedia quite intensively.
>
> Please help!
>
> Dirk
Received on Tue Apr 16 2002 - 06:47:32 CDT