Oracle 视图 DBA_HIST_BUFFERED_SUBSCRIBERS 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 DBA_HIST_BUFFERED_SUBSCRIBERS 官方解释，作用，如何使用详细说明 10-19

本站中文解释

Oracle视图： DBA_HIST_BUFFERED_SUBSCRIBERS
用途：用于查询当前正在运行的延迟订阅服务器写入缓冲区的订户。

使用方法：
1、首先确认当前是否有延迟订阅服务器正在运行，可通过SELECT * FROM V$INSTANCE 视图来查询；
2、然后使用 SELECT * FROM DBA_HIST_BUFFERED_SUBSCRIBERS 这个视图来查看系统当前正在运行的延迟订阅服务器写入缓冲区的订户的情况；
3、此视图的查询列序列号、实例名称、订户名称、当前活动订户列表以及其他信息。

官方英文解释

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

编辑：广州鸿名健康科技有限公司

标签：订户,视图,缓冲区,正在运行,服务器