My Oracle Support Banner

AUTO SGA: Disabling Background Sga Auto-tuning Message Leading To ORA-4031 (Doc ID 1579855.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


Immediately after database open completed, the following messages regarding AUTO SGA are reported.

Tue Aug 27 10:32:42 EDT 2013
Tue Aug 27 10:32:55 EDT 2013
AUTO SGA: Could not access 5, db cache advisor.
AUTO SGA: Disabling background sga auto-tuning.

Which then leads to a flood of ORA-4031 errors leaving database unusable.

ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kkj jobq  wor")
ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","library cache")


 Moved database to new hardware with many CPU's.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.