| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
This view 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 |
