Re: %Total Call Time in AWR

Lei,

you can check $ORACLE_HOME/rdbms/admin/awrrpt.sql
This generates your reports, so you can see what's going on.

hth


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: