查询Oracle日志中的SQL

示例如下所示：

exec DBMS_LOGMNR.add_logfile('/archlog/1_1437_879452462.dbf',dbms_logmnr.addfile);

 

exec DBMS_LOGMNR.START_LOGMNR(OPTIONS =>SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

 

select SCN, TIMESTAMP, COMMIT_TIMESTAMP,sql_redo,sql_undo from v$logmnr_contents where seg_owner='PMCS' and sql_redolike '%PMCSBEST0101%';

 

 ALTER TABLE"PMCS"."PMCSBEST0101" ADD SUPPLEMENTAL LOG DATA (ALL)COLUMNS;

 

 SQL> select SCN, TIMESTAMP, COMMIT_TIMESTAMP,sql_redo,sql_undo from v$logmnr_contents where seg_owner='PMCS' and sql_redolike '%PMCSBEST0101%';

2.4369E+102016-03-18 11:24:11

ALTERTABLE "PMCS"."PMCSBEST0101" ADD SUPPLEMENTAL LOG DATA (ALL)COLUMNS