欢迎光临
我们一直在努力

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

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。