Dynamic Performance (V$) Views, 115 of 179

V$PX_SESSION

This view contains information about the sessions running parallel execution.

Column	Datatype	Description
`SADDR`	`RAW(4)`	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 parallel server process belongs
`SERVER_SET`	`NUMBER`	The logical set of servers that this parallel server process belongs to. A single server group will have at most two server sets
`SERVER#`	`NUMBER`	The logical number of a parallel server 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 prior to any resource, multi-user, or load balancing reductions