SQL HISTORY ACTIVE SESSION

select a.sql_id,a.module,a.program,dbms_lob.substr(b.sql_text,4000,1), a.client_id
from dba_hist_active_sess_history a, dba_hist_sqltext b
where sample_time between to_date('20120611:19:00','yyyymmdd:hh24:mi')
and to_date('20120611:19:30','yyyymmdd:hh24:mi') and b.sql_id=a.sql_id
and b.sql_text like '%F5949025%'