|
USER_ID |
NUMBER |
|
User ID Number of the Resumable Statement Owner |
|
SESSION_ID |
NUMBER |
|
Session Identifier of Resumable Statement |
|
INSTANCE_ID |
NUMBER |
|
Instance Number of Resumable Statement |
|
COORD_SESSION_ID |
NUMBER |
|
Session Identifier of Parallel Coordinator |
|
COORD_INSTANCE_ID |
NUMBER |
|
Instance Number on which the Parallel Coordinator is Running |
|
SQL_TEXT |
VARCHAR2(1000) |
|
The resumable statement, selected from the V$SQL view. |
|
NAME |
VARCHAR2(4000) |
|
The name given in the resumable clause of this resumable statement. |
|
STATUS |
VARCHAR2(16) |
|
The status of the resumable statement. Its value can be one of RUNNING, SUSPENDED, ABORTED, ABORTING, TIMEOUT |
|
ERROR_NUMBER |
NUMBER |
|
The error code of the last correctable error. When STATUS is equal to RUNNING, its value will be set to 0. |
|
ERROR_MSG |
VARCHAR2(4000) |
|
The error message corresponding to ERROR_NUMBER. It will be set to NULL when ERROR_NUMBER is NULL. |
|
ERROR_PARAMETER1 |
VARCHAR2(80) |
|
The first parameter for the error message. NULL if no error. |
|
ERROR_PARAMETER2 |
VARCHAR2(80) |
|
The second parameter for the error message. NULL if no error. |
|
ERROR_PARAMETER3 |
VARCHAR2(80) |
|
The third parameter for the error message. NULL if no error. |
|
ERROR_PARAMETER4 |
VARCHAR2(80) |
|
The forth parameter for the error message. NULL if no error. |
|
ERROR_PARAMETER5 |
VARCHAR2(80) |
|
The fifth parameter for the error message. NULL if no error. |
|
START_TIME |
DATE |
|
The start local time of the resumable statement. |
|
SUSPEND_TIME |
DATE |
|
The last local time when the resumable statement was suspended. It is initialized to NULL. |
|
RESUME_TIME |
DATE |
|
The last local time when the suspended resumable statement is resumed. It is initialized to NULL. |
|
TIMEOUT |
NUMBER |
|
Timeout of the resumable statement |
