Listing

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;

Views

Resources

Readings