DBA_HIST_BUFFERED_SUBSCRIBERS

DBA_HIST_BUFFERED_SUBSCRIBERS displays historical information about the subscribers for all buffered queues in the instance.

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`QUEUE_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue
`SUBSCRIBER_ID`	`NUMBER`	`NOT NULL`	Internal subscriber number (for identification)
`SUBSCRIBER_NAME`	`VARCHAR2(30)`		Name of the subscriber
`SUBSCRIBER_ADDRESS`	`VARCHAR2(1024)`		Address of the subscribing agent
`SUBSCRIBER_TYPE`	`VARCHAR2(30)`		Type of subscriber: `PROXY` - Proxy subscriber `SUBSCRIBOR`
`STARTUP_TIME`	`DATE`	`NOT NULL`	Startup time of the instance
`LAST_BROWSED_SEQ`^Foot 1	`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`^Footref 1	`NUMBER`		Internal Message number for the most recently browsed message for the subscriber
`LAST_DEQUEUED_SEQ`^Footref 1	`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`^Footref 1	`NUMBER`		Internal Message number for the most recently dequeued message for the subscriber
`CURRENT_ENQ_SEQ`^Footref 1	`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 creation of the buffered queue
`TOTAL_DEQUEUED_MSG`^Footref 1	`NUMBER`		Total number of messages dequeued by the subscriber
`TOTAL_SPILLED_MSG`	`NUMBER`		Total number of spilled messages for the subscriber
`EXPIRED_MSGS`^Footref 1	`NUMBER`		Number of expired messages
`MESSAGE_LAG`^Footref 1	`NUMBER`		Message lag of the subscriber
`ELAPSED_DEQUEUE_TIME`^Footref 1	`NUMBER`		Total time spent in dequeue (in hundredths of a second)
`DEQUEUE_CPU_TIME`^Footref 1	`NUMBER`		Total CPU time for dequeue (in hundredths of a second)
`LAST_DEQUEUE_TIME`^Footref 1	`TIMESTAMP(3)`		Last message dequeue time
`OLDEST_MSGID`^Footref 1	`RAW(16)`		Message ID of the oldest message
`OLDEST_MSG_ENQTM`^Footref 1	`TIMESTAMP(3)`		Enqueue time of the oldest message

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