BEGIN
DBMS_LOGMNR.START_LOGMNR( STARTTIME => to_date('16-06-2015 02:30:00', 'DD-MM-YYYY HH24:MI:SS'),
ENDTIME => to_date('16-06-2015 03:24:00', 'DD-MM-YYYY HH24:MI:SS'),
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.CONTINUOUS_MINE);
END;
/
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.5bf0] :
BLOCKED 0x25fdd4a10 5 wq 2 cvtops x1 TX 0x1e001e.0x25064(ext 0x6,0x0)[33000-0002-0000763F] inst 2
BLOCKER 0x25fdd4840 5 wq 1 cvtops x28 TX 0x1e001e.0x25064(ext 0x6,0x0)[25000-0002-00011FA8] inst 2
BLOCKED 0x255c1fcb0 5 wq 2 cvtops x1 TX 0x1f0018.0x3ba08(ext 0x6,0x0)[25000-0002-00011FA8] inst 2
BLOCKER 0x255c1fae0 5 wq 1 cvtops x28 TX 0x1f0018.0x3ba08(ext 0x6,0x0)[33000-0002-0000763F] inst 2
0x1e001e.0x25064
0x1f0018.0x3ba08
WITH x AS
( SELECT LPAD('1e001e', 8, '0') AS a, LPAD('25064', 8, '0') b FROM dual )
SELECT TO_NUMBER(SUBSTR(a, 1,4), 'xxxx') AS xidusn,
TO_NUMBER(substr(a, 5,8), 'xxxx') AS xidslt,
TO_NUMBER(b, 'xxxxxxxx') AS xidsqn
FROM x;
SELECT * FROM V$LOGMNR_CONTENTS WHERE xidusn=30 AND xidslt=30 AND xidsqn=151652;
WITH x AS
( SELECT LPAD('1f0018', 8, '0') AS a, LPAD('3ba08', 8, '0') b FROM dual )
SELECT TO_NUMBER(SUBSTR(a, 1,4), 'xxxx') AS xidusn,
TO_NUMBER(substr(a, 5,8), 'xxxx') AS xidslt,
TO_NUMBER(b, 'xxxxxxxx') AS xidsqn
FROM x;
SELECT * FROM V$LOGMNR_CONTENTS WHERE xidusn=31 AND xidslt=24 AND xidsqn=244232;