Oracle 视图 V$BUFFERED_SUBSCRIBERS 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图V$BUFFERED_SUBSCRIBERS用于查询用户在提供缓冲订阅服务时所需的一些信息。由于缓冲订阅服务可以加快查询的性能,因此V$BUFFERED_SUBSCRIBERS可以帮助开发人员更好地了解如何使用并有效使用缓冲订阅服务。

使用V$BUFFERED_SUBSCRIBERS时,可以查看存储在缓冲区中的信息,例如:分配的缓冲大小,确定现有缓冲区是否同步,缓冲区中保存的行数,上次更新缓冲区的时间和缓冲区订阅时间。此外,可以使用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(128)

Owner of the queue

QUEUE_NAME

VARCHAR2(128)

Name of the queue

SUBSCRIBER_ID

NUMBER

Internal subscriber number (for identification)

SUBSCRIBER_NAME

VARCHAR2(512)

Name of the subscriber

SUBSCRIBER_ADDRESS

VARCHAR2(1024)

Address of the subscribing agent

PROTOCOL

NUMBER

Protocol of the subscribing agent

SUBSCRIBER_TYPE

VARCHAR2(128)

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_AGE

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

CON_ID

NUMBER

The ID of the container to which the data pertains. 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 视图 V$BUFFERED_SUBSCRIBERS 官方解释,作用,如何使用详细说明