V$SESSION_EVENT

Columns
   ___________________________
 
   SID
   EVENT
   MAX_WAIT
   AVERAGE_WAIT
   TIME_WAITED
   TOTAL_TIMEOUTS
   TOTAL_WAITS

Related Views:

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