AUTO SGA: Disabling Background Sga Auto-tuning Message Leading To ORA-4031
Last updated on APRIL 04, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 to 188.8.131.52 [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
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")
Moved database to new hardware with many CPU's.
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