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

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 16 Apr 2002 15:48:37 +0600
Message-ID: <a9gs1q$30s45$1@ID-127142.news.dfncis.de>

Hi,

try to play with JAVA_POOL_SIZE parameter. For more info see thread below named 'Export problem - so many synonyms'. Very likely you have the same issue.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

"Dirk Versavel" <dirk.versavel_at_smartlounge.be> wrote in message
news:4eeeef52.0204152330.7ad9f467_at_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 - 04:48:37 CDT