SQL history


<br />
SELECT  a.sql_id, a.user_id, a.module<br />
FROM  V$ACTIVE_SESSION_HISTORY a<br />
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')<br />
and a.session_id=933;<br />

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;