VIEW: SYS.INT$DBA_HIST_PERSISTENT_QUEUES

Source

View Text - Preformatted

select pqs.snap_id, pqs.dbid, pqs.instance_number, pqs.queue_schema,
       pqs.queue_name,pqs.queue_id, pqs.first_activity_time, pqs.enqueued_msgs,
       pqs.dequeued_msgs, pqs.browsed_msgs, pqs.elapsed_enqueue_time,
       pqs.elapsed_dequeue_time, pqs.enqueue_cpu_time, pqs.dequeue_cpu_time,
       pqs.avg_msg_age, pqs.dequeued_msg_latency,
       pqs.elapsed_transformation_time, pqs.elapsed_rule_evaluation_time,
       pqs.enqueued_expiry_msgs, pqs.enqueued_delay_msgs,
       pqs.msgs_made_expired, pqs.msgs_made_ready, pqs.last_enqueue_time,
       pqs.last_dequeue_time, pqs.last_tm_expiry_time, pqs.last_tm_ready_time,
       pqs.enqueue_transactions, pqs.dequeue_transactions, pqs.execution_count,
       decode(pqs.con_dbid, 0, pqs.dbid, pqs.con_dbid),
       con_dbid_to_id(decode(pqs.con_dbid, 0, pqs.dbid, pqs.con_dbid)) con_id
  from wrh$_persistent_queues pqs, DBA_HIST_SNAPSHOT sn
  where     sn.snap_id          = pqs.snap_id
        and sn.dbid             = pqs.dbid
        and sn.instance_number  = pqs.instance_number

View Text - HTML Formatted

SELECT PQS.SNAP_ID
, PQS.DBID
, PQS.INSTANCE_NUMBER
, PQS.QUEUE_SCHEMA
, PQS.QUEUE_NAME
, PQS.QUEUE_ID
, PQS.FIRST_ACTIVITY_TIME
, PQS.ENQUEUED_MSGS
, PQS.DEQUEUED_MSGS
, PQS.BROWSED_MSGS
, PQS.ELAPSED_ENQUEUE_TIME
, PQS.ELAPSED_DEQUEUE_TIME
, PQS.ENQUEUE_CPU_TIME
, PQS.DEQUEUE_CPU_TIME
, PQS.AVG_MSG_AGE
, PQS.DEQUEUED_MSG_LATENCY
, PQS.ELAPSED_TRANSFORMATION_TIME
, PQS.ELAPSED_RULE_EVALUATION_TIME
, PQS.ENQUEUED_EXPIRY_MSGS
, PQS.ENQUEUED_DELAY_MSGS
, PQS.MSGS_MADE_EXPIRED
, PQS.MSGS_MADE_READY
, PQS.LAST_ENQUEUE_TIME
, PQS.LAST_DEQUEUE_TIME
, PQS.LAST_TM_EXPIRY_TIME
, PQS.LAST_TM_READY_TIME
, PQS.ENQUEUE_TRANSACTIONS
, PQS.DEQUEUE_TRANSACTIONS
, PQS.EXECUTION_COUNT
, DECODE(PQS.CON_DBID
, 0
, PQS.DBID
, PQS.CON_DBID)
, CON_DBID_TO_ID(DECODE(PQS.CON_DBID
, 0
, PQS.DBID
, PQS.CON_DBID)) CON_ID
FROM WRH$_PERSISTENT_QUEUES PQS
, DBA_HIST_SNAPSHOT SN
WHERE SN.SNAP_ID = PQS.SNAP_ID
AND SN.DBID = PQS.DBID
AND SN.INSTANCE_NUMBER = PQS.INSTANCE_NUMBER