DBA_RESUMABLE displays all resumable statements executed in the system.
USER_RESUMABLE displays the resumable statements executed by the current user. This view does not display the USER_ID column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
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:
|
|
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 (initialized to NULL) | |
RESUME_TIME |
VARCHAR2(20) |
Last time the suspended resumable statement was resumed (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 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 0. |
See Also:
"USER_RESUMABLE"