Database Tuning (MOSC)

MOSC Banner

[10.2.0.4] analyzing AWR report

edited Jun 28, 2010 2:01AM in Database Tuning (MOSC) 9 commentsAnswered
Hi, Here's the Time Model Statistics part of my report :
My question is :
If DB CPU = 655 and total DB Time = 1900, How do you explain that the sum of the other roww is not equal to (DB Time - DB CPU).
Where could I find the detail of wait time (DB Time-DB CPU) ?

Rgds,

sql execute elapsed time 1,744.05 91.77
DB CPU 655.91 34.51
parse time elapsed 150.31 7.91
hard parse elapsed time 136.94 7.21
failed parse elapsed time 62.29 3.28
PL/SQL execution elapsed time 1.25 0.07
hard parse (sharing criteria) elapsed time 0.37 0.02
PL/SQL compilation elapsed time 0.07 0.00
connection management call elapsed time 0.06 0.00
repeated bind elapsed time 0.05 0.00
hard parse (bind mismatch) elapsed time

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