AUTO SGA: Disabling Background Sga Auto-tuning Message Leading To ORA-4031
(Doc ID 1579855.1)
Last updated on APRIL 04, 2016
Oracle Database - Enterprise Edition - Version 10.2.0.5 to 220.127.116.11 [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!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|