VIEW: SYS.INT$DBA_HIST_STREAMS_APPLY_SUM

Source

View Text - Preformatted

select sas.snap_id, sas.dbid, sas.instance_number, sas.apply_name,
       sas.startup_time, sas.reader_total_messages_dequeued, sas.reader_lag,
       sas.coord_total_received, sas.coord_total_applied,
       sas.coord_total_rollbacks, sas.coord_total_wait_deps,
       sas.coord_total_wait_cmts, sas.coord_lwm_lag,
       sas.server_total_messages_applied, sas.server_elapsed_dequeue_time,
       sas.server_elapsed_apply_time,
       decode(sas.con_dbid, 0, sas.dbid, sas.con_dbid),
       con_dbid_to_id(decode(sas.con_dbid, 0, sas.dbid, sas.con_dbid)) con_id
  from wrh$_streams_apply_sum sas, DBA_HIST_SNAPSHOT sn
  where     sas.session_module = 'Streams'
        and sn.snap_id          = sas.snap_id
        and sn.dbid             = sas.dbid
        and sn.instance_number  = sas.instance_number

View Text - HTML Formatted

SELECT SAS.SNAP_ID
, SAS.DBID
, SAS.INSTANCE_NUMBER
, SAS.APPLY_NAME
, SAS.STARTUP_TIME
, SAS.READER_TOTAL_MESSAGES_DEQUEUED
, SAS.READER_LAG
, SAS.COORD_TOTAL_RECEIVED
, SAS.COORD_TOTAL_APPLIED
, SAS.COORD_TOTAL_ROLLBACKS
, SAS.COORD_TOTAL_WAIT_DEPS
, SAS.COORD_TOTAL_WAIT_CMTS
, SAS.COORD_LWM_LAG
, SAS.SERVER_TOTAL_MESSAGES_APPLIED
, SAS.SERVER_ELAPSED_DEQUEUE_TIME
, SAS.SERVER_ELAPSED_APPLY_TIME
, DECODE(SAS.CON_DBID
, 0
, SAS.DBID
, SAS.CON_DBID)
, CON_DBID_TO_ID(DECODE(SAS.CON_DBID
, 0
, SAS.DBID
, SAS.CON_DBID)) CON_ID
FROM WRH$_STREAMS_APPLY_SUM SAS
, DBA_HIST_SNAPSHOT SN
WHERE SAS.SESSION_MODULE = 'STREAMS'
AND SN.SNAP_ID = SAS.SNAP_ID
AND SN.DBID = SAS.DBID
AND SN.INSTANCE_NUMBER = SAS.INSTANCE_NUMBER