AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC)

MOSC Banner

Weaknesses of orachk 12.1.0.2.6

edited Sep 9, 2020 3:26PM in AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC) 2 commentsAnswered

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                                         

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center