常用的logmnr脚本

BEGIN
SYS.DBMS_LOGMNR.ADD_LOGFILE('e:oracleoradatauniplatredolog01.log');
SYS.DBMS_LOGMNR.ADD_LOGFILE('e:oracleoradatauniplatredolog02.log');
SYS.DBMS_LOGMNR.ADD_LOGFILE('e:oracleoradatauniplatredolog03.log');
SYS.DBMS_LOGMNR.START_LOGMNR(STARTTIME => TO_DATE('04-06-17 16:50',
'yy-mm-dd hh24:mi'),
ENDTIME => TO_DATE('04-06-17 16:55',
'yy-mm-dd hh24:mi'),
OPTIONS => SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
END;
SELECT * FROM V$LOGMNR_CONTENTS WHERE USERNAME = 'GRAINTEST';
SELECT A.USERNAME, A.SESSION_INFO, A.SEG_NAME, A.SEG_TYPE_NAME,
A.TABLE_SPACE, A.SQL_REDO, A.SQL_UNDO
FROM V$LOGMNR_CONTENTS A
WHERE A.USERNAME = 'GRAINTEST';
BEGIN SYS.DBMS_LOGMNR.END_LOGMNR();END;