SGA: allocation forcing component growth
This event is printed, when the SGA is not sufficient to handle the memory load. If this event is continuously printed in the database, then there may be chances of ora-04031 or ora-04036 to occur etc..
USERNAM W_CHAINS TIMER_SEC CHART_WCLASS SQL_ID TOTAVGACT PER%AS
------- -------------------------------------------------- ---------- -------------------- ------------- ---------- ----------
SYS |SGA: allocation forcing component growth [|]<~~~ 160626 OOOOOOOOOOOOOOOOOOO .42 1608.8
SGA: allocation forcing component growth| OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
OOOOOOOOOOOOOOOOOOOO
Solution:
This is capacity issue of SGA and the components inside SGA grows beyond current memory size either it be AMM or ASMM.
Increase SGA.