Oracle教程

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

本站中文解释

V$PX_SESSION视图属于V$ Performance Views，是Oracle数据库中用于查看并行查询会话信息的视图，其中包含了相关数据库会话连接和并行查询信息。

V$PX_SESSION主要包含如下字段：

PID：参与并行操作的进程号
QC_INSTANCE_ID：并行查询操作实例ID
SESSION_ADDR：会话地址
SESSION_TYPE：会话类型
SESSION_STATE：会话状态
QESPID：每个并行会话分配的并行查询进程
PGA_ALLOCATED：会话中的本地工作区大小
DBMS_PQ_STATUS：会话的并行操作状态

使用V$PX_SESSION在数据库中查看会话信息，可利用SQL查询语句，查询字段如：PID，SESSION_TYPE，SESSION_STATE，QESPID，PGA_ALLOCATED，DBMS_PQ_STATUS等：

SELECT PID,SESSION_TYPE,SESSION_STATE,QESPID,PGA_ALLOCATED,DBMS_PQ_STATUS FROM V$PX_SESSION;

官方英文解释

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

Column Datatype Description

SADDR

RAW(4 | 8)

Session address

SID

NUMBER

Session identifier

SERIAL#

NUMBER

Session serial number

QCSID

NUMBER

Session identifier of the parallel coordinator

QCSERIAL#

NUMBER

Session serial number of the parallel coordinator

QCINST_ID

NUMBER

Instance number on which the parallel coordinator is running

SERVER_GROUP

NUMBER

The logical group of servers to which this cluster database process belongs

SERVER_SET

NUMBER

The logical set of servers to which this cluster database process belongs. A single server group will have at most two server sets.

SERVER#

NUMBER

The logical number of the cluster database process within a server set

DEGREE

NUMBER

The degree of parallelism being used by the server set

REQ_DEGREE

NUMBER

The degree of parallelism that was requested by the user when the statement was issued and before any resource, multiuser, or load balancing reductions

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

相关推荐