V$PX_SESSION
contains information about the sessions running parallel execution.
Column | Datatype | Description |
---|---|---|
|
|
Session address |
|
|
Session identifier |
|
|
Session serial number |
|
|
Session identifier of the parallel coordinator |
|
|
Session serial number of the parallel coordinator |
|
|
Instance number on which the parallel coordinator is running |
|
|
The logical group of servers to which this cluster database process belongs |
|
|
The logical set of servers to which this cluster database process belongs. A single server group will have at most two server sets. |
|
|
The logical number of the cluster database process within a server set |
|
|
The degree of parallelism being used by the server set |
|
|
The degree of parallelism that was requested by the user when the statement was issued and before any resource, multiuser, or load balancing reductions |
|
|
The ID of the container to which the data pertains. Possible values include:
|