Oracle教程

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

本站中文解释

？

Oracle视图V$PX_PROCESS_SYSSTAT被用于显示出应用工作流程阶段的系统状态信息。它是当前正在运行的每个可分派作业和在分派作业上执行操作的进程的记录。

V$PX_PROCESS_SYSSTAT提供了一个明确的和简单的方法来监视每个当前应用程序流程的状态以及给定操作的状态的信息。该视图还列出了可分派任务的型号，当前数量，总数量和活动数量，以及它们正在执行的操作。

可以通过使用V$PX_PROCESS_SYSSTAT视图来检查并监视应用程序流程的运行情况，从而帮助改善内存使用，减少计算资源的利用率，识别任务的潜在延迟，监视状态失败的任务，以及确定当前正在运行的作业和模式。

官方英文解释

V$PX_PROCESS_SYSSTAT contains information about the sessions running parallel execution.

Column Datatype Description

STATISTIC

VARCHAR2(30)

Name of the statistic:

  • Servers In Use – Number of PX servers currently performing parallel operations

  • Servers Available – Number of PX servers available to perform parallel operations

  • Servers Started – Number of times the system has had to create a PX server process

  • Servers Shutdown – Number of times a PX server process has been shut down. A PX server process will be shut down if it has not been used recently.

    If this value is large, then consider increasing the parameter. This will improve performance by avoiding the latency of PX server process creation.

  • Servers HWM – Maximum number of concurrent PX server processes

    If this number is equal to the PARALLEL_MAX_SERVERS initialization parameter, then consider increasing the parameter. This could allow you to increase your throughput, especially if your system is under-utilized and the V$SYSSTAT statistic “Parallel operations downgraded to serial” is large.

  • Servers Cleaned Up – Number of times PMON had to clean up a PX server. This should only happen during abnormal termination of a parallel operation.

    If this number is large, then you should determine the cause.

  • Server Sessions – Total number of sessions created by all PX servers

  • Memory Chunks Allocated – Number of large memory chunks allocated by PX servers

  • Memory Chunks Freed – Number of large memory chunks freed

  • Memory Chunks Current – Number of large memory chunks currently being used

  • Memory Chunks HWM – Maximum number of concurrently allocated chunks

  • Buffers allocated – Number of times a message buffer has been allocated

  • Buffers freed – Number of times a message buffer has been freed

  • Buffers Current – Number of message buffers currently being used

  • Buffers HWM – Maximum number of concurrently allocated message buffers

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

相关推荐