| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |
|
 Copyright © 2002, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
