SGA: allocation forcing component growth

From DB Optimizer
Jump to: navigation, search

Oracle: SGA: allocation forcing component growth

see: http://dba.5341.com/msg/63184.html

466399 (SYSTEM WIDE HANG ON
MMON WAITING FOR 'SGA ALLOCATION FORCING COMPONENT GROWTH'),
   4472338 (duplicate of the above 4466399) 
   4507532 (turned out to be a bad diagnosis, but the bug is real) 
   4920199 

If necessary turn off the automatic tuning features by setting sga_target = 0.