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

 

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 (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"