Question: see the following waits in my AWR for
our prod instance:
Event Waits Time(s)
Avg wait (ms) % DB time Wait Class
SGA: allocation forcing component
growth 85,883 5,062 59 32.57 Other
cursor: pin S wait
on X
4,091 3,913 957 25.18 Concurrency
library cache load
lock
694 2,256 3251 14.52 Concurrency
library cache: mutex X
883 1,626 1842 10.46 Concurrency
DB CPU
917 5.90
How do I resolve this SGA: allocation
forcing component growth wait?
Answer: The
SGA: allocation forcing component growth indicates
that you can Automatic Memory Management (AMM) turned-on
This is an AMM message indicating that the size
of sga_target or memory_target is too small, causing
excessive AMM resize operations.
The solution is to
turn off AMM and allocate your own db_cache_size and
shared_pool_size and un-setting sga_target and
memory_target.
