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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: