col event format a30 col sample_time format a25 select session_id, sample_time, session_state, event, wait_time, time_waited, sql_id, sql_child_number CH# from v$active_session_history where user_id = 92 order by session_id, sample_time;