Dynamic Performance (V$) Views, 142 of 238

V$PX_PROCESS

This view contains information about the sessions running parallel execution.

Column	Datatype	Description
`SERVER_NAME`	`VARCHAR2(4)`	The name of the cluster database (P000, P001, etc)
`STATUS`	`VARCHAR2(9)`	The state of the cluster database (`IN USE`\|`AVAILABLE`)
`PID`	`NUMBER`	The process identifier
`SPID`	`VARCHAR2(9)`	The OS process ID
`SID`	`NUMBER`	The session ID of slave, if in use
`SERIAL#`	`NUMBER`	The session serial number of slave, if in use