Oracle 视图 V$PERSISTENT_PUBLISHERS 官方解释，作用，如何使用详细说明
本站中文解释
_INFO
Oracle视图“V$PERSISTENT_PUBLISHERS_INFO”记录发布者当前连接的网络服务和它们的联机状态。
发布者是在Oracle Streams环境中捕获并转发数据的进程。这个视图的内容可能在Streams的配置更改后发生变化。
这个视图可以使用来监控Streams环境中发布者的连接和状态，以便可以确保环境正常运行。
使用方法：
1. 在Oracle数据库会话中，选择对应的表空间，执行如下指令：
SELECT * FROM V$PERSISTENT_PUBLISHERS_INFO;
2. 该查询将显示发布者，其连接的服务和状态。
官方英文解释
V$PERSISTENT_PUBLISHERS displays information about all active publishers of the persistent queues in the database. There is one row per instance per queue per publisher. The rows are deleted 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 |
|
|
|
Address of the publisher agent |
|
|
|
Protocol used by the publisher’s address |
|
|
|
Number of messages that have been enqueued |
|
|
|
Total time spent doing enqueue (in hundredths of a second) |
|
|
|
Total CPU time for enqueue (in hundredths of a second) |
|
|
|
Last enqueue message timestamp |
|
|
|
Number of enqueue transactions |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
