Ask the Expert

ORA-04031 in the job queue process

I am running Oracle 9.2.0.4 on HP-UX11. I am seeing a lot of error 4031 in the job queue process:
 ORA-04031: unable to allocate 27192 bytes of shared memory ("shared 
 pool","unknown object","sga heap(1,0)","session param values")
 OPIRIP: Uncaught error 447. Error stack:
 ORA-00447: fatal error in background process
My settings for shared pool are: 
 
shared_pool_size=150994944
shared_pool_reserved_size=15099494
Ideas?

    Requires Free Membership to View

    Login

Your Shared Pool is too small. This can be verified by running the following query: 

select * from v$sgastat where name='free memory';
If the value for the Shared Pool's free memory is a small number, i.e. less than 1 or 2 megabytes, then consider increasing your SHARED_POOL_SIZE initialization parameter. You might need to bounce the database for this value to take effect.


This was first published in July 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top