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 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

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

Tue Aug 27 10:32:42 EDT 2013
Completed: ALTER DATABASE OPEN
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")

Changes

 Moved database to new hardware with many CPU's.

Cause

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 hundreds of Community platforms