SELECT snap_id,
sample_time,
session_type,
session_id,sql_opname,
sql_id,
event,
p1,
p2,
blocking_session,
blocking_hangchain_info,
current_obj#,
machine
FROM DBA_HIST_ACTIVE_SESS_HISTORY
WHERE sample_time BETWEEN TO_DATE ('2013-10-19 08:00', 'yyyy-mm-dd hh24:mi')
AND TO_DATE ('2013-10-19 10:00', 'yyyy-mm-dd hh24:mi')
ORDER BY 1,