查找sequence的脚本

select THREAD#,SEQUENCE#,FIRST_CHANGE#, FIRST_TIME from v$log_history where FIRST_TIME > to_date('20090608:0100','yyyymmdd:HH24mi') and FIRST_TIME < to_date('20090608:0700','yyyymmdd:HH24mi') order by FIRST_CHANGE#;