Oracle 视图 V$PQ_SLAVE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 v$pq_slave 用于查询 Oracle Parallel Query 针对数据库并行查询的节点信息。它可以帮助查看和监控由 Oracle 并行查询涉及的所有和在 Oracle 数据库中分配的节点，也称为 Oracle Parallel Query Slave Sesions 或 Oracle Parallel Query Processor Slave 会话。
v$pq_slave 视图中，用户可以深入查询 PQ Slave Session 的运行状态，以及特定数据库用户是如何实现某一 PQ Session 的并行查询。
使用该视图时，可以使用以下语法查看所有针对数据库中当前活动 PQ 启动的元素：
SELECT * FROM v$pq_slave;
运行该查询，将返回所有关于实现并行查询的细节，包括实例号、服务名、会话 ID 和其他有关 PQ Session 的信息。
官方英文解释
V$PQ_SLAVE lists statistics for each of the active parallel execution servers on an instance.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Name of the parallel execution server |
|
|
|
Current status of the parallel execution server:
|
|
|
|
Number of sessions that have used this parallel execution server |
|
|
|
Amount of time spent idle while processing statements in the current session |
|
|
|
Amount of time spent busy while processing statements in the current session |
|
|
|
Amount of CPU time spent on the current session |
|
|
|
Number of messages sent while processing statements for the current session |
|
|
|
Number of messages received while processing statements for the current session |
|
|
|
Total amount of time this query server has been idle |
|
|
|
Total amount of time this query server has been active |
|
|
|
Total amount of CPU time this query server has used to process statements |
|
|
|
Total number of messages this query server has sent |
|
|
|
Total number of messages this query server has received |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
