execute dbms_logmnr_d.build(dictionary_filename => 'dict.ora',dictionary_location => '/rman/utlfile');

execute dbms_logmnr.add_logfile(LogFileName => '/oraarchive/1_659_596981628.arc',Options => dbms_logmnr.new);

execute dbms_logmnr.start_logmnr(DictFileName => '/rman/utlfile/dict.ora');

create table logmnr3 as select * from GV$LOGMNR_CONTENTS;

execute dbms_logmnr.end_logmnr;

exec dbms_logmnr.add_logfile('/oraarchive/1_659_596981628.arc',dbms_logmnr.removefile);

[@more@]

ITPub博客

logmnr挖掘