5.289 DBA_RESUMABLE
DBA_RESUMABLE
displays all resumable statements executed in the system.
Related View
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 of the Resumable Statement Owner |
|
|
|
Session Identifier of the Resumable Statement |
|
|
|
Instance Number of the Resumable Statement |
|
|
|
Instance Number on which the Parallel Coordinator is Running |
|
|
|
Session Identifier of the Parallel Coordinator |
|
|
|
Status of the resumable statement:
|
|
|
|
Timeout of the resumable statement |
|
|
|
Start time of the resumable statement |
|
|
|
Last time the resumable statement was suspended (initialized to NULL) |
|
|
|
Last time the suspended resumable statement was resumed (initialized to NULL) |
|
|
|
Name given in the resumable clause of the resumable statement |
|
|
|
Resumable statement, selected from the |
|
|
|
Error code of the last correctable error. When |
|
|
|
First parameter for the error message (NULL if no error) |
|
|
|
Second parameter for the error message (NULL if no error) |
|
|
|
Third parameter for the error message (NULL if no error) |
|
|
|
Forth parameter for the error message (NULL if no error) |
|
|
|
Fifth parameter for the error message (NULL if no error) |
|
|
|
Error message corresponding to |
See Also: