%Total Call Time in AWR

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

• ------------ ----------- ------ ------

  ---

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

log file parallel write 97,921 523 5 5.4 System I/O  

Thanks,

Lei

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 16 2009 - 18:17:35 CDT