%Total Call Time in AWR
- From: "Lei Zeng" <lzeng@xxxxxxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Jul 2009 16:17:35 -0700
Hi.
I have a quick question here,
For the awr report, the 'Top 5 Timed Events' section, does anybody knows
how the '%Total Call Time ' is calculated for each event listed there?
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
Wait Class
------------------------------ ------------ ----------- ------ ------
----------
PX Deq Credit: send blkd 5,682,600 3,816 1 39.8
Other
db file scattered read 91,236 1,681 18 17.5
User I/O
CPU time 1,347 14.0
log file sync 99,426 752 8 7.8
Commit
log file parallel write 97,921 523 5 5.4
System I/O
Thanks,
Lei
Other related posts:
