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

On Aug 31, 9:25 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> <sybra..._at_hccnet.nl> wrote in message
>
> news:elied399l73aj422h1smmj4e0n85tjupj7_at_4ax.com...
>
>
>
>
>
> > On Thu, 30 Aug 2007 11:00:49 -0700, purohita..._at_gmail.com wrote:
>
> >>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.
>
> >>-Atul
>
> > As already noted, shared server requires the large pool to be
> > configured. If you don't configure the large pool, the shared pool
> > will be used for shared server purposes.
> > Please be aware any crystal balls required are usually out of order,
> > shattered, broken or all of them.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Sybrand,
>
> When the error message tells you that you can't allocate memory
> in the shared pool for a hash join, it's fairly obvious that the system
> is 9i or earlier with shared servers configured but no large pool.
>
> So when the OP offers an apology for failing to supply a version number
> there really isn't any need to make snide comments about crystal balls.
>
> --
> Regards
>
> Jonathan Lewishttp://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentalshttp://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html- Hide quoted text -
>
> - Show quoted text -

Thank you all.
As you guys said, we did not have a large pool configured. Now we have a large pool of 500mb and shared pool to 1 gig..that seems to have solved the problem. For the time being at least. :)

-Atul Received on Fri Aug 31 2007 - 13:09:12 CDT