V$SESSION_WAIT

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

Related Views:

V$ACCESS
V$MYSTAT 
V$PROCESS 				
V$SESSION 
V$SESSION_CONNECT_INFO 
V$SESSION_CURSOR_CACHE 
V$SESSION_EVENT 
V$SESSION_LONGOPS 
V$SESSION_OBJECT_CACHE 
V$SESSTAT 
V$SESS_IO