DBA_RESUMABLE

Oracle 11gR1

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: · 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.

Oracle data dictionary views