V$BUFFERED_SUBSCRIBERS

V$BUFFERED_SUBSCRIBERS displays information about the subscribers for all buffered queues in the instance. There is one row per subscriber per queue.

Column Datatype Description
QUEUE_ID NUMBER Identifier for the queue
QUEUE_SCHEMA VARCHAR2(30) Owner of the queue
QUEUE_NAME VARCHAR2(30) Name of the queue
SUBSCRIBER_ID NUMBER Internal subscriber number (for identification)
SUBSCRIBER_NAME VARCHAR2(30) Name of the subscriber (comparable to the Streams name for the Streams process)
SUBSCRIBER_ADDRESS VARCHAR2(1024) Address of the subscribing agent
PROTOCOL NUMBER Protocol of the subscribing agent
SUBSCRIBER_TYPE VARCHAR2(30) Type of the subscriber:
  • PROXY - Proxy subscriber

  • SUBSCRIBER

STARTUP_TIME DATE Startup time
LAST_BROWSED_SEQ NUMBER Sequence number of the most recently browsed message for the subscriber (comparable to the number of messages in the V$STREAMS_APPLY_READER view)
LAST_BROWSED_NUM NUMBER Internal Message number for the most recently browsed message for the subscriber
LAST_DEQUEUED_SEQ NUMBER Sequence number of the most recently dequeued message for the subscriber (comparable to the number of messages in the V$STREAMS_APPLY_COORDINATOR view)
LAST_DEQUEUED_NUM NUMBER Internal Message number for the most recently dequeued message for the subscriber
CURRENT_ENQ_SEQ NUMBER Current sequence number of the most recently enqueued message for the subscriber
NUM_MSGS NUMBER Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk)
CNUM_MSGS NUMBER Cumulative total number of messages enqueued for the subscriber since the database last started
TOTAL_DEQUEUED_MSG NUMBER Total number of messages dequeued by the subscriber
TOTAL_SPILLED_MSG NUMBER Total number of spilled messages for the subscriber
EXPIRED_MSGS NUMBER Number of expired messages
MESSAGE_LAG NUMBER Message lag of the subscriber
ELAPSED_DEQUEUE_TIME NUMBER Total time spent in dequeue (in hundredths of a second)
DEQUEUE_CPU_TIME NUMBER Total CPU time for dequeue (in hundredths of a second)
AVG_MSG_AGEFoot 1  NUMBER Average age of messages currently enqueued in the buffered queue for the subscriber
LAST_DEQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE Last message dequeue time
OLDEST_MSGID RAW(16) Message ID of the oldest message
OLDEST_MSG_ENQTM TIMESTAMP(3) Enqueue time of the oldest message

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).