Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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


See Also:

"USER_RESUMABLE"