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

From: Dirk Versavel <dirk.versavel_at_smartlounge.be>
Date: 16 Apr 2002 00:30:03 -0700
Message-ID: <4eeeef52.0204152330.7ad9f467@posting.google.com>

Dear,

I'm running oracle 8.1.7 on RedHat Linux 6.2.

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 - 02:30:03 CDT