Oracle教程

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

本站中文解释

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


数据运维技术 » Oracle 视图 DBA_HIST_BUFFERED_SUBSCRIBERS 官方解释，作用，如何使用详细说明
分享到：

相关推荐