Database Tuning (MOSC)

MOSC Banner

%DB Time in AWR report seem wrong.

edited Mar 22, 2019 8:50PM in Database Tuning (MOSC) 5 commentsAnswered

Hi, I have a RAC 2 node DB. Today, I get awr on 1 node to monitor database working.

I pay attention to % DB time. As I know that DB Time = CPU I/O Time + Non Idle waittime.

But in my AWR Report, sum of % Non Idle waittime is more than 100%.

Could you explain this case for me?

Thank in advance

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DFS lock handle67,50631.3K46353.5Other
DB CPU 15.5K 26.5
log file sync2,320,8119995.3417.1Commit
db file sequential read1,858,4394925.538.4User I/O
inactive transaction branch5,4924893.98918.4Other
gc buffer busy acquire1,038,723295835.1Cluster

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