1.先执行alter session set nls_date_format='mm/dd/yyyy hh24:mi';
2.select * from v$log_history;
3.
begin
dbms_logmnr.start_logmnr(startTime => '&startdate',
endTime => '&enddate',
Options => dbms_logmnr.DICT_FROM_ONLINE_CATALOG +
dbms_logmnr.CONTINUOUS_MINE);
end;
4.select * from v$logmnr_contents;
5.select * from tab$;
6.select * from dba_objects;
2.select * from v$log_history;
3.
begin
dbms_logmnr.start_logmnr(startTime => '&startdate',
endTime => '&enddate',
Options => dbms_logmnr.DICT_FROM_ONLINE_CATALOG +
dbms_logmnr.CONTINUOUS_MINE);
end;
4.select * from v$logmnr_contents;
5.select * from tab$;
6.select * from dba_objects;