Dynamic Performance (V$) Views, 113 of 179

V$PX_PROCESS

This view contains information about the sessions running parallel execution.

Column	Datatype	Description
`SERVER_NAME`	`VARCHAR2(4)`	The name of the parallel server (P000, P001, etc)
`STATUS`	`VARCHAR2(9)`	The state of the parallel server. Either In Use or 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