Re: %Total Call Time in AWR

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

--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s