VIEW: SYS.INT$DBA_HIST_CAPTURE

Source

View Text - Preformatted

select cs.snap_id, cs.dbid, cs.instance_number, cs.capture_name,
       cs.startup_time, cs.lag,
       cs.total_messages_captured, cs.total_messages_enqueued,
       cs.elapsed_rule_time, cs.elapsed_enqueue_time,
       cs.elapsed_redo_wait_time, cs.elapsed_pause_time,
       decode(cs.con_dbid, 0, cs.dbid, cs.con_dbid),
       cs.extract_name,
       cs.bytes_redo_mined, cs.bytes_sent, cs.session_module,
       con_dbid_to_id(decode(cs.con_dbid, 0, cs.dbid, cs.con_dbid)) con_id
  from wrh$_streams_capture cs, DBA_HIST_SNAPSHOT sn
  where sn.snap_id              = cs.snap_id
        and sn.dbid             = cs.dbid
        and sn.instance_number  = cs.instance_number

View Text - HTML Formatted

SELECT CS.SNAP_ID
, CS.DBID
, CS.INSTANCE_NUMBER
, CS.CAPTURE_NAME
, CS.STARTUP_TIME
, CS.LAG
, CS.TOTAL_MESSAGES_CAPTURED
, CS.TOTAL_MESSAGES_ENQUEUED
, CS.ELAPSED_RULE_TIME
, CS.ELAPSED_ENQUEUE_TIME
, CS.ELAPSED_REDO_WAIT_TIME
, CS.ELAPSED_PAUSE_TIME
, DECODE(CS.CON_DBID
, 0
, CS.DBID
, CS.CON_DBID)
, CS.EXTRACT_NAME
, CS.BYTES_REDO_MINED
, CS.BYTES_SENT
, CS.SESSION_MODULE
, CON_DBID_TO_ID(DECODE(CS.CON_DBID
, 0
, CS.DBID
, CS.CON_DBID)) CON_ID
FROM WRH$_STREAMS_CAPTURE CS
, DBA_HIST_SNAPSHOT SN
WHERE SN.SNAP_ID = CS.SNAP_ID
AND SN.DBID = CS.DBID
AND SN.INSTANCE_NUMBER = CS.INSTANCE_NUMBER