DROP TABLE logmnr_temp PURGE;
exec sys.dbms_logmnr.add_logfile(LogFileName=>'D:/oracle/product/10.2.0/oradata/FUNDCLEA/REDO01.LOG',options=>dbms_logmnr.new);
exec sys.dbms_logmnr.add_logfile(LogFileName=>'D:/oracle/product/10.2.0/oradata/FUNDCLEA/REDO02.LOG',options=>dbms_logmnr.ADDFILE);
exec sys.dbms_logmnr.add_logfile(LogFileName=>'D:/oracle/product/10.2.0/oradata/FUNDCLEA/REDO03.LOG',options=>dbms_logmnr.ADDFILE);
exec sys.dbms_logmnr.start_logmnr(options=>sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
--分析某时间段 exec dbms_logmnr.start_logmnr
(startTime => to_date('20080413100000','yyyy-mm-dd hh24:mi:ss'),
endTime => to_date('20080413150000','yyyy-mm-dd hh24:mi:ss'),
options=>sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
create table logmnr_temp as select * from V$logmnr_Contents;
exec sys.dbms_logmnr.end_logmnr;