Oracle - 特定時間帯のSQL抽出

set term on

set wrap on

set trimspool on

set pagesize 1000

set linesize 2000

set numwidth 10

set long 9999

spool sql.txt

select SAMPLE_TIME,MACHINE,PROGRAM,USER_ID,SQL_TEXT

from DBA_HIST_ACTIVE_SESS_HISTORY a,DBA_HIST_SQLTEXT b

where

SAMPLE_TIME >= to_timestamp('2012/04/20 01:55:00.000','yyyy/mm/dd hh24:mi:ss.ff3') AND

SAMPLE_TIME < to_timestamp('2012/04/20 02:15:00.000','yyyy/mm/dd hh24:mi:ss.ff3') AND

a.SQL_ID = b.SQL_ID

order by SAMPLE_TIME DESC,MACHINE,PROGRAM,USER_ID;

spool off