VIEW: SYS.INT$DBA_HIST_BUF_SUBSCRIBERS

Source

View Text - Preformatted

select ss.snap_id, ss.dbid, ss.instance_number, ss.queue_schema, ss.queue_name,
       ss.subscriber_id, ss.subscriber_name, ss.subscriber_address,
       ss.subscriber_type, ss.startup_time, ss.last_browsed_seq,
       ss.last_browsed_num, ss.last_dequeued_seq, ss.last_dequeued_num,
       ss.current_enq_seq, ss.num_msgs, ss.cnum_msgs,
       ss.total_dequeued_msg, ss.total_spilled_msg, ss.expired_msgs,
       ss.message_lag, ss.elapsed_dequeue_time, ss.dequeue_cpu_time,
       ss.last_dequeue_time, ss.oldest_msgid, ss.oldest_msg_enqtm,
       decode(ss.con_dbid, 0, ss.dbid, ss.con_dbid),
       con_dbid_to_id(decode(ss.con_dbid, 0, ss.dbid, ss.con_dbid)) con_id
  from wrh$_buffered_subscribers ss, DBA_HIST_SNAPSHOT sn
  where     sn.snap_id          = ss.snap_id
        and sn.dbid             = ss.dbid
        and sn.instance_number  = ss.instance_number

View Text - HTML Formatted

SELECT SS.SNAP_ID
, SS.DBID
, SS.INSTANCE_NUMBER
, SS.QUEUE_SCHEMA
, SS.QUEUE_NAME
, SS.SUBSCRIBER_ID
, SS.SUBSCRIBER_NAME
, SS.SUBSCRIBER_ADDRESS
, SS.SUBSCRIBER_TYPE
, SS.STARTUP_TIME
, SS.LAST_BROWSED_SEQ
, SS.LAST_BROWSED_NUM
, SS.LAST_DEQUEUED_SEQ
, SS.LAST_DEQUEUED_NUM
, SS.CURRENT_ENQ_SEQ
, SS.NUM_MSGS
, SS.CNUM_MSGS
, SS.TOTAL_DEQUEUED_MSG
, SS.TOTAL_SPILLED_MSG
, SS.EXPIRED_MSGS
, SS.MESSAGE_LAG
, SS.ELAPSED_DEQUEUE_TIME
, SS.DEQUEUE_CPU_TIME
, SS.LAST_DEQUEUE_TIME
, SS.OLDEST_MSGID
, SS.OLDEST_MSG_ENQTM
, DECODE(SS.CON_DBID
, 0
, SS.DBID
, SS.CON_DBID)
, CON_DBID_TO_ID(DECODE(SS.CON_DBID
, 0
, SS.DBID
, SS.CON_DBID)) CON_ID
FROM WRH$_BUFFERED_SUBSCRIBERS SS
, DBA_HIST_SNAPSHOT SN
WHERE SN.SNAP_ID = SS.SNAP_ID
AND SN.DBID = SS.DBID
AND SN.INSTANCE_NUMBER = SS.INSTANCE_NUMBER