Re: Why is time_waited more than total elapsed time ?

This isn't going into parallel execution is it ? When PX slaves execute, the QC ends up
summing their v$sesstat figures, but doesn't capture their v$session_event figures.
This would explain why the v$system_event figures climb dramatically whilst the v$session_event for that sid don't move.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Bass Chorng wrote in message ...


>

>

>EVENT

>TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT

>----------------------------------------------------------------

>----------- -------------- ----------- ------------

>db file sequential read

>81835              0       42370   .517749129

>

>11:11:29 opwvdb SQL> select * from v$session_event where sid = 13 and

>event = 'db file sequential read';

>       SID EVENT

>     TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT

>---------- ----------------------------------------------------------------

>----------- -------------- ----------- ------------

>  MAX_WAIT

>----------

>        13 db file sequential read

>               8              0           2          .25

>         1