-----目标端apply情况

Set lines 132

col apply_name for a15

col source_database for a15

select apply_name,source_database,applied_message_number,oldest_message_number,apply_time from dba_apply_progress;

----源端capture情况

set lines 132

col session_name for a20

col capture_name for a15

col sid for 999

col logminer_id for 999

col state for a20

select * from  gv$logmnr_session order by session_name;

Select session_id,session_name,session_state,num_process,start_scn,spill_scn,processed_scn,low_mark_scn,consumed_scn from gv$logmnr_session;

select capture_name,queue_name,status,applied_scn,captured_scn,start_scn from dba_capture;

select sid,serial#,capture_name,logminer_id,state,CAPTURE_TIME ,CAPTURE_MESSAGE_NUMBER,ENQUEUE_MESSAGE_NUMBER from gv$streams_capture

---这个CAPTURE_MESSAGE_NUMBER是在不断增加的，基本上接近系统的scn号，而ENQUEUE_MESSAGE_NUMBER是只有在捕捉到变化时才会增加

SQL> select sid,serial#,capture_name,logminer_id,state,CAPTURE_TIME ,CAPTURE_MESSAGE_NUMBER,ENQUEUE_MESSAGE_NUMBER from gv$streams_capture;

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383799                 383544

SQL> delete from scott.t2 where rownum=1;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select sid,serial#,capture_name,logminer_id,state,CAPTURE_TIME ,CAPTURE_MESSAGE_NUMBER,ENQUEUE_MESSAGE_NUMBER from gv$streams_capture;

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383830                 383830

SQL> /

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383840                 383830

SQL> /

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383992                 383855

SQL> /

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383996                 383855

SQL> /

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383996                 383855

SQL> /

 SID    SERIAL# CAPTURE_NAME    LOGMINER_ID STATE                CAPTURE_T CAPTURE_MESSAGE_NUMBER ENQUEUE_MESSAGE_NUMBER

---- ---------- --------------- ----------- -------------------- --------- ---------------------- ----------------------

  40          1 CAPTURE_XJNY             42 CAPTURING CHANGES    22-AUG-11                 383996                 383855