Re: ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")

From: Krish <Krishna.Bussu_at_gmail.com>
Date: Thu, 30 Aug 2007 08:35:58 -0700
Message-ID: <1188488158.507857.152250@k79g2000hse.googlegroups.com>

On Aug 30, 12:55 am, purohita..._at_gmail.com wrote:
> We getting the following error in our database:
> ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared
> pool","unknown object","hash-join subh","QERHJ Hash Table Entries")"
>
> We have already tried the following:
> 1. Flushing shared pool
> 2. Bouncing db
>
> Bouncing does resolve the problem temporarily but then it comes back
> again?
> Size of the shared pool has been same throughtout but problem has
> started to appear recently.
> Any clues anyone?

You may need to increase the setting for SGA_TARGET to allow MMAN more memory to manage behind the scenes if you experience ORA-04031 errors in the Large Pool, Streams Pool, or Java Pool.

The Shared Pool is little more complicated to tune. Please refer metalink article 396940.1 for more information to resovle this issue.

Krish Received on Thu Aug 30 2007 - 10:35:58 CDT