VIEW: SYS.INT$DBA_HIST_PERSISTENT_SUBS

Source

View Text - Preformatted

select pss.snap_id, pss.dbid, pss.instance_number,
       pss.queue_schema, pss.queue_name, pss.subscriber_id,
       pss.subscriber_name, pss.subscriber_address, pss.subscriber_type,
       pss.first_activity_time, pss.enqueued_msgs, pss.dequeued_msgs,
       pss.avg_msg_age, pss.browsed_msgs,
       pss.expired_msgs, pss.dequeued_msg_latency, pss.last_enqueue_time,
       pss.last_dequeue_time, pss.elapsed_dequeue_time,pss.dequeue_cpu_time,
       pss.dequeue_transactions, pss.execution_count,
       decode(pss.con_dbid, 0, pss.dbid, pss.con_dbid),
       con_dbid_to_id(decode(pss.con_dbid, 0, pss.dbid, pss.con_dbid)) con_id
  from wrh$_persistent_subscribers pss, DBA_HIST_SNAPSHOT sn
  where     sn.snap_id          = pss.snap_id
        and sn.dbid             = pss.dbid
        and sn.instance_number  = pss.instance_number

View Text - HTML Formatted

SELECT PSS.SNAP_ID
, PSS.DBID
, PSS.INSTANCE_NUMBER
, PSS.QUEUE_SCHEMA
, PSS.QUEUE_NAME
, PSS.SUBSCRIBER_ID
, PSS.SUBSCRIBER_NAME
, PSS.SUBSCRIBER_ADDRESS
, PSS.SUBSCRIBER_TYPE
, PSS.FIRST_ACTIVITY_TIME
, PSS.ENQUEUED_MSGS
, PSS.DEQUEUED_MSGS
, PSS.AVG_MSG_AGE
, PSS.BROWSED_MSGS
, PSS.EXPIRED_MSGS
, PSS.DEQUEUED_MSG_LATENCY
, PSS.LAST_ENQUEUE_TIME
, PSS.LAST_DEQUEUE_TIME
, PSS.ELAPSED_DEQUEUE_TIME
, PSS.DEQUEUE_CPU_TIME
, PSS.DEQUEUE_TRANSACTIONS
, PSS.EXECUTION_COUNT
, DECODE(PSS.CON_DBID
, 0
, PSS.DBID
, PSS.CON_DBID)
, CON_DBID_TO_ID(DECODE(PSS.CON_DBID
, 0
, PSS.DBID
, PSS.CON_DBID)) CON_ID
FROM WRH$_PERSISTENT_SUBSCRIBERS PSS
, DBA_HIST_SNAPSHOT SN
WHERE SN.SNAP_ID = PSS.SNAP_ID
AND SN.DBID = PSS.DBID
AND SN.INSTANCE_NUMBER = PSS.INSTANCE_NUMBER