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.

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.

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.

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.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$PX_PROCESS_SYSSTAT 官方解释，作用，如何使用详细说明