Q

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?

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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close