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 |