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 |
---|---|---|
|
|
Identifier for the queue |
|
|
Owner of the queue |
|
|
Name of the queue |
|
|
Internal subscriber number (for identification) |
|
|
Name of the subscriber |
|
|
Address of the subscribing agent |
|
|
Protocol of the subscribing agent |
|
|
Type of the subscriber:
|
|
|
Startup time |
|
|
Sequence number of the most recently browsed message for the subscriber (comparable to the number of messages in the |
|
|
Internal Message number for the most recently browsed message for the subscriber |
|
|
Sequence number of the most recently dequeued message for the subscriber (comparable to the number of messages in the |
|
|
Internal Message number for the most recently dequeued message for the subscriber |
|
|
Current sequence number of the most recently enqueued message for the subscriber |
|
|
Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk) |
|
|
Cumulative total number of messages enqueued for the subscriber since the database last started |
|
|
Total number of messages dequeued by the subscriber |
|
|
Total number of spilled messages for the subscriber |
|
|
Number of expired messages |
|
|
Message lag of the subscriber |
|
|
Total time spent in dequeue (in hundredths of a second) |
|
|
Total CPU time for dequeue (in hundredths of a second) |
|
|
Average age of messages currently enqueued in the buffered queue for the subscriber |
|
|
Last message dequeue time |
|
|
Message ID of the oldest message |
|
|
Enqueue time of the oldest message |
|
|
The ID of the container to which the data pertains. Possible values include:
|