Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
DBA_RESUMABLE
lists all resumable statements executed in the system.
Related View
USER_RESUMABLE
lists 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. 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. |
See Also:
"USER_RESUMABLE"