Oracle 视图 V$BUFFERED_PUBLISHERS 官方解释，作用，如何使用详细说明
本站中文解释
：
Oracle视图V$BUFFERED_PUBLISHERS可以用来查看基于流的重复技术（Streams）环境中已缓冲的发布者（publishers）。该视图表示当前缓冲区（buffer）中存在的各发布者和它们的信息。可以通过该视图来监测流传播活动以及通过显示有关流传播发布者的信息，帮助我们更好地管理Streams环境中的配置发布者。
使用方法：
1.查询缓冲区中当前可用的发布者：
SELECT * FROM v$buffered_publishers;
2.查询缓冲区中当前变量的发布者：
SELECT * FROM v$buffered_publishers WHERE name = ‘Name’;
3.查询缓冲区中已暂停的发布者：
SELECT * FROM v$buffered_publishers WHERE status = ‘PAUSED’;
4.查询缓冲区中配置的发布者：
SELECT * FROM v$buffered_publishers WHERE is_configured = 1;
官方英文解释
V$BUFFERED_PUBLISHERS displays information about all buffered publishers in the instance.
There is one row per queue per sender. The values are reset to zero when the database (or instance in an Oracle RAC environment) restarts.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Identifier for the queue |
|
|
|
Owner of the queue |
|
|
|
Name of the queue |
|
|
|
Name of the agent enqueuing the message (the Streams name assigned for a capture process) |
|
|
|
Queue name and database name of the source (last propagating) queue; database name is not specified if the source queue is in the local database |
|
|
|
Protocol used by the sender’s address |
|
|
|
Current number of messages that have yet to be dequeued from the buffer queue |
|
|
|
Cumulative total number of messages enqueued into the buffered queue since the database last started |
|
|
|
Most recently enqueued message identifier |
|
|
|
Number of messages that have been enqueued but not browsed |
|
|
|
Number of messages that have been spilled but not browsed |
|
|
|
Percentage of the Streams pool that is being used (or |
|
|
|
Total time spent in enqueue (in hundredths of a second) |
|
|
|
Total CPU time for enqueue (in hundredths of a second) |
|
|
|
Last message enqueue time |
|
|
|
State of the publisher:
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
