Log Miner setup steps:
https://www.thegeekdiary.com/simple-steps-to-use-logminer-for-finding-high-redo-log-generation/
Just in case the link will move, the main steps are below:
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/u01/app/oracle/users/Florin/MYDB_1_714407_821540104.arc',OPTIONS => DBMS_LOGMNR.NEW);
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/u01/app/oracle/users/Florin/MYDB_1_714408_821540104.arc',OPTIONS => DBMS_LOGMNR.ADDFILE);
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR( -
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);>
PL/SQL procedure successfully completed.
SQL> l
1 select USERNAME,OS_USERNAME,MACHINE_NAME,SESSION_INFO from V$LOGMNR_CONTENTS
2 where TABLE_NAME='MY_TABLE'
3 and OPERATION='DELETE'
4* and rownum < 11
No comments:
Post a Comment