V$PX_PROCESS

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

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