ORACHK report shows WARNING about frequency of SGA resize operations
we saw this warning after running ORACHK on our 11.2.0.3 database. We can see messages like this :
Status on APBWOES:
WARNING => Consider investigating the frequency of SGA resize operations and take corrective action
DATA FOR APBWOES FOR MONITORING SGA RESIZE OPERATIONS
COMPONENT OPER_TYPE COUNT(1)
------------------------- ------------- ----------
shared pool GROW 27
DEFAULT buffer cache SHRINK 27
shared pool SHRINK 27
DEFAULT buffer cache GROW 27
We wanna know about the "count(1)" column.
1) How does this metric be measured ? And count 27 means that we have resize our shared pool/buffer cache since when ? Since the last db instance reboot ?
2)What is the threshold about this metric ? Can you tell us more precisely such as if this metric over 10 count means too more resize operation ?