[10.2.0.4] analyzing AWR report
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,
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 |
0