Re: Why - ORA-04031: unable to allocate 740 bytes of shared memory

JimmyN1 wrote:

> also, try tuning your sql. run traces on it to see why it requires soo much
> shared_pool.

Since its a third party product, modifying the program's sql is probably not a solution. A good idea, but not a viable one, unless one happens to have the source available.

ORA-04031 is caused by a lack of shared pool resources. This could be due to fragmentations of the shared_pool or that the shared pool is set too low. Also check to see if you are hitting a bug with the shared_pool size, there were at least one dealing with shared_pool for oracle 7. Not sure what off hand. Also are you running oracle parrallel query, if yes you may have to adjust your SHARED_POOL_SIZE , SHARED_POOL_RESERVED_SIZE , and SHARED_POOL_RESERVED_MIN_ALLOC appropriately. But before fiddling with these parameters, see if your ORA-04031 was a result of fragmentation in the library cache or in the shared pool reserved space.

If all else fail, get a newer version of the program from the vendor with better written sql.

Michael Received on Tue Aug 07 2001 - 15:17:01 CDT