ORA-04031: unable to allocate 2097152 bytes of shared memory("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")
in [Oracle]
|
From: Brian Peasland on 30 Aug 2007 15:59 purohitatul(a)gmail.com wrote: > 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 >>> 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(a)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
|
Pages: 1 Prev: Oracle11 & statistics calculations Next: trouble with RAC db start |