V$SESSION_WAIT

Columns
   ___________________________
 
   SECONDS_IN_WAIT
   P3
   P3TEXT
   P2RAW
   P2
   P2TEXT
   P1RAW
   P1
   P1TEXT
   EVENT
   SID
   P3RAW
   WAIT_TIME
   STATE
   SEQ#

Related Commands: