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

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 30 Aug 2007 14:59:50 -0500
Message-ID: <46d715ac$0$16321$88260bb3@free.teranews.com>

purohitatul_at_gmail.com wrote:
> On Aug 29, 11:25 pm, sybra..._at_hccnet.nl wrote:

>> On Thu, 30 Aug 2007 05:55:19 -0000, 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?
>> Posts without version should be avoided.
>> You are using bind variables?
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA

>
> Sorry...missed putting the version..its 9.2.0.8.
> Also, we have recently implemented shared server configuration.
> I was't a part of the implementation but are there any parameters that
> can to be looked to verify that alls configured correctly and memory
> allocation is proper.
> On bind variables, we don't really have a buzy system this one, its
> have very few user and running mostly stand alone queries.
>
> Thanks for your inputs,
> Atul
>

when you configured your shared servers, did you adequately size the Large Pool at the same time?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Thu Aug 30 2007 - 14:59:50 CDT