Re: %Total Call Time in AWR
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 18 Jul 2009 07:33:18 +0100
It's the event wait time divided by the "DB Time" - which you
may find just under the snapshot begin/end lines near the top of
the report, but will otherwise be in the Time Model Statistics
section of the report.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
----- Original Message -----
From: "Lei Zeng" <lzeng@xxxxxxxxxxxxx>
To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, July 17, 2009 12:17 AM
Subject: %Total Call Time in AWR
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
