Oracle教程

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

本站中文解释

Oracle视图V$PQ_SYSSTAT可以用来报告libq 任务系统状态信息。 V$PQ_SYSSTAT用于显示有关系统当前的并行查询的信息，这包括：

（1）当前工作的并行查询任务总数；

（2）最大并行查询任务总数；

（3）拒绝活动并行查询任务的总数；

（4）进行中的seek+scan会话数；

（5）当前正在运行的PX任务数；

（6）最大正在运行的PX任务总数；

（7）最大活动的PX会话的总数；

（8）拒绝活动的PX会话的总数；

（9）当前正在测试的用户定义过程（UDF）数量；

（10）最大正在测试的用户定义过程（UDF）数量等。

使用V$PQ_SYSSTAT视图：

SELECT * FROM V$PQ_SYSSTAT;

该查询将返回Oracle系统中当前的并行查询(PQ)状态。

官方英文解释

V$PQ_SYSSTAT lists system statistics for parallel queries. After you have run a query or DML operation, you can use the information derived from V$PQ_SYSSTAT to view the number of slave processes used, and other information for the system.
Column Datatype Description

STATISTIC

VARCHAR2(30)

Name of the statistic:

  • Servers Busy – Number of currently busy servers on this instance

  • Servers Idle – Number of currently idle servers on this instance

  • Servers Highwater – Number of active servers on this instance that have partaken in >= 1 operation so far

  • Server Sessions – Total number of operations executed in all servers on this instance

  • Servers Started – Total number of servers started on this instance

  • Servers Shutdown – Total number of servers shutdown on this instance

  • Servers Cleaned Up – Total number of servers on this instance cleaned up due to process death

  • Queries Initiated – Total number of parallel queries initiated on this instance

  • DDL Initiated – Total number of parallel DDL operations that were initiated

  • DML Initiated – Total number of parallel DML operations that were initiated

  • DFO Trees – Total number of DFO trees executed on this instance

  • Local Msgs Sent – Total number of local (intra-instance) messages sent on this instance

  • Distr Msgs Sent – Total number of remote (inter-instance) messages sent on this instance

  • Local Msgs Recv'd – Total number of remote (inter-instance) messages received on this instance

  • Distr Msgs Recv'd – Total number of remote (inter-instance) messages received on this instance

VALUE

NUMBER

Value of the statistic

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$PQ_SYSSTAT 官方解释，作用，如何使用详细说明
分享到：

相关推荐