4.297 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(128)	NOT NULL	Owner of the queue
QUEUE_NAME	VARCHAR2(128)	NOT NULL	Name of the queue
SUBSCRIBER_ID	NUMBER	NOT NULL	Internal subscriber number (for identification)
SUBSCRIBER_NAME	VARCHAR2(128)		Name of the subscriber
SUBSCRIBER_ADDRESS	VARCHAR2(1024)		Address of the subscribing agent
SUBSCRIBER_TYPE	VARCHAR2(128)		Type of subscriber: PROXY - Proxy subscriber SUBSCRIBOR
STARTUP_TIME	DATE	NOT NULL	Startup time of the instance
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 creation of the buffered queue
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)
LAST_DEQUEUE_TIME	TIMESTAMP(3)		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
CON_DBID	NUMBER		The database ID of the PDB for the sampled session
CON_ID	NUMBER		The ID of the container that CON_DBID identifies. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data