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

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 Received on Thu Aug 30 2007 - 13:02:00 CDT