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

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