SQL history

March 2nd, 2012
SELECT  a.sql_id, a.user_id, a.module
FROM  V$ACTIVE_SESSION_HISTORY a
where a.sample_time between to_date('17/06/2011 00:00', 'dd/mm/yyyy hh24:mi') and to_date('17/06/2011 23:50', 'dd/mm/yyyy hh24:mi')
and a.session_id=933;
Comments are closed.