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 126.96.36.199 [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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!