Oracle Logminer


EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '+FRA/DB/ARCHIVELOG/thread_1_seq_50580.13976.996480557', OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '+FRA/DB/ARCHIVELOG/thread_2_seq_118282.27897.996480577', OPTIONS => DBMS_LOGMNR.ADDFILE);
EXECUTE DBMS_LOGMNR.START_LOGMNR( STARTTIME => '15-Jan-2019 15:27:00', ENDTIME => '15-Jan-2019 15:28:00', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTED_DATA_ONLY);
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
EXECUTE DBMS_LOGMNR.END_LOGMNR;

create table ops$oracle.logminer_20190311 parallel (degree 8) as select /*+ parallel (x,8) */ * from x$logmnr_contents x;

set lines 2000 pages 100
col xid format a32
col luba format a32
select data_obj#, xidusn||'.'|| xidslt||'.'|| xidsqn xid, operation,
rollback, RS_ID,substr(LUBA_AFN||'.'||LUBA_DBA||'.'|| LUBA_SLOT||'.'||
LUBA_RCI||'.'|| LUBA_OBJN||'.'||LUBA_FSCNT,1,30) LUBA from x$logmnr_contents
where xidusn=53 and xidslt=25 and xidsqn=1303692;

create index logminer_xid_idx on logminer_20190311(XIDUSN, XIDSLT, XIDSQN) parallel 8;

create index logminer_rid_idx on logminer_20190311(row_id) parallel 8;
 
drop table logminer_20190311 purge;