Session Wait Events

Hi...

-

I have the next query with its respective outcome.

-

select s.username,s.machine,s.sid,s.serial#,sw.event,sw.wait_class,sw.seconds_in_wait,sw.state
 from v$session s, v$session_wait sw
where sw.sid=s.sid and s.username='TOPAZ' order by sw.seconds_in_wait;

-

USERNAME   MACHINE                     SID    SERIAL# EVENT                          WAIT_CLASS           SECONDS_IN_WAIT STATE
---------- ------------------------- ---------- ---------- ------------------------------ -------------------- --------------- -------------------
TOPAZ      p2000app1                       1983      26337 gc cr request                                 Cluster                            0 WAITING
TOPAZ      p2000app1                       1985      31488 SQL*Net message from client           Idle                               0 WAITING
TOPAZ      p2000app1                        951      10596 db file sequential read                     User I/O                           0 WAITING