USER_ID |
NUMBER |
|
User ID Number of the Resumable Statement Owner |
SESSION_ID |
NUMBER |
|
Session Identifier of the Resumable Statement |
INSTANCE_ID |
NUMBER |
|
Instance Number of the Resumable Statement |
COORD_INSTANCE_ID |
NUMBER |
|
Instance Number on which the Parallel Coordinator is Running |
COORD_SESSION_ID |
NUMBER |
|
Session Identifier of the Parallel Coordinator |
STATUS |
VARCHAR2(9) |
|
Status of the resumable statement:
-
RUNNING
-
SUSPENDED
-
TIMEOUT
-
ERROR
-
ABORTED
|
TIMEOUT |
NUMBER |
|
Timeout of the resumable statement |
START_TIME |
VARCHAR2(20) |
|
Start time of the resumable statement |
SUSPEND_TIME |
VARCHAR2(20) |
|
Last time the resumable statement was suspended. It is initialized to null. |
RESUME_TIME |
VARCHAR2(20) |
|
Last time the suspended resumable statement was resumed. It is initialized to null. |
NAME |
VARCHAR2(4000) |
|
Name given in the resumable clause of the resumable statement |
SQL_TEXT |
VARCHAR2(1000) |
|
Resumable statement, selected from the V$SQL view |
ERROR_NUMBER |
NUMBER |
|
Error code of the last correctable error. When STATUS is set to RUNNING , its value will be set to 0. |
ERROR_PARAMETER1 |
VARCHAR2(80) |
|
First parameter for the error message (null if no error) |
ERROR_PARAMETER2 |
VARCHAR2(80) |
|
Second parameter for the error message (null if no error) |
ERROR_PARAMETER3 |
VARCHAR2(80) |
|
Third parameter for the error message (null if no error) |
ERROR_PARAMETER4 |
VARCHAR2(80) |
|
Forth parameter for the error message (null if no error) |
ERROR_PARAMETER5 |
VARCHAR2(80) |
|
Fifth parameter for the error message (null if no error) |
ERROR_MSG |
VARCHAR2(4000) |
|
Error message corresponding to ERROR_NUMBER . It will be null when ERROR_NUMBER is null. |