Monitor the Elapsed Times
select sid, capture#, capture_name,
ELAPSED_CAPTURE_TIME/100 capture_time ,
ELAPSED_RULE_TIME/100 rule_time ,
ELAPSED_ENQUEUE_TIME/100 enqueue_time ,
ELAPSED_LCR_TIME/100 lcr_time ,
ELAPSED_REDO_WAIT_TIME/100 redo_wait_time,
ELAPSED_PAUSE_TIME/100 pause_time
from V$STREAMS_CAPTURE
/
In the next section, the Apply related
views will be introduced.