Weaknesses of orachk 12.1.0.2.6
I have executed orachk on one of our database servers and it shows some weaknesses:
-> Check: Consider investigating the frequency of SGA resize operations
Status on DB1:
WARNING => Consider investigating the frequency of SGA resize operations and take corrective action
COMPONENT OPER_TYPE COUNT(1)
------------------------- ------------- ----------
DEFAULT buffer cache SHRINK 1
shared pool GROW 1
In my opinion, when resize ops is 1, this is not necessarily a high frequency. (Threshold of > 0 seems to low for this warning)
-> Check: Consider investigating the sessions that are currently waiting and take necessary action
SID: 97 WAITING Wait Event: Streams AQ: waiting for messages in the queue Waiting(seconds): 2