Oracle DB 12.1.0.2
Hello Team,
can you please advise how can I tune logminer?
I will configure logminer using redo logs only and not archivelogs
I have added the redo logs as follows:
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/app/PMTG/db/apps_st/data/log01a.dbf', -
OPTIONS => DBMS_LOGMNR.NEW);>
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/app/PMTG/db/apps_st/data/log02a.dbf', -
OPTIONS => DBMS_LOGMNR.ADDFILE);> >
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/app/PMTG/db/apps_st/data/log03a.dbf', -
OPTIONS => DBMS_LOGMNR.ADDFILE);> >
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR
(STARTSCN => 315614665840, ENDSCN => 315615487985,
OPTIONS => DBMS_LOGMNR.SKIP_CORRUPTION+ DBMS_LOGMNR.NO_SQL_DELIMITER+DBMS_LOGMNR.NO_ROWID_IN_STMT+ DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
PL/SQL procedure successfully completed.
where startscn and endscn is from v$log;
SQL> set arraysize 1000
SQL> set timing on
SQL> SELECT * FROM V$LOGMNR_CONTENTS WHERE TABLE_NAME = 'TABLENOTEXIT';
no rows selected
Elapsed: 00:02:49.90
Rate= archived_log_count x archive_log_size / duration.
3 x 1.074/(60/2.8)
=0.15 G/hr
Trace file is attached (virus free)
PMTG2_ora_50135104_SQL10046.rar (12.9 KB)Thanks,
Roshan