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

<sybrandb_at_hccnet.nl> wrote in message
news:elied399l73aj422h1smmj4e0n85tjupj7_at_4ax.com...
> On Thu, 30 Aug 2007 11:00:49 -0700, purohitatul_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 Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html