I am running Oracle 18.104.22.168 on HP-UX11. I am seeing a lot of error 4031 in the job queue process:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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 processMy settings for shared pool are:
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.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.