DBA_RESUMABLE

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	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: `RUNNING` `SUSPENDED` `TIMEOUT` `ERROR` `ABORTED`
`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.