From: Brian Peasland on 30 Aug 2007 15:59
> On Aug 29, 11:25 pm, sybra...(a)hccnet.nl wrote:
>> On Thu, 30 Aug 2007 05:55:19 -0000, purohita...(a)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
>>> 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 22.214.171.124.
> 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,
when you configured your shared servers, did you adequately size the
Large Pool at the same time?
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