SET TIME ON VERIFY OFF

COLUMN    event                  FORMAT A40               HEADING 'Event'    TRUNCATE
COLUMN    total_waits            FORMAT 999,999,999       HEADING 'Total Waits'
COLUMN    time_waited_micro      FORMAT 999,999,999,999   HEADING 'Time Waited (us)'



SELECT     se.event, 
           se.total_waits, 
           se.time_waited_micro
FROM       v$session_event se
WHERE      se.sid = &&user_sid
  AND      se.time_waited_micro > 0
ORDER BY   se.time_waited_micro DESC
/