|
USER_ID
|
NUMBER
|
|
User ID Number of the Resumable Statement Owner
|
|
SESSION_ID
|
NUMBER
|
|
Session Identifier of Resumable Statement
|
|
INSTANCE_ID
|
NUMBER
|
|
Instance Number of Resumable Statement
|
|
COORD_SESSION_ID
|
NUMBER
|
|
Session Identifier of Parallel Coordinator
|
|
COORD_INSTANCE_ID
|
NUMBER
|
|
Instance Number on which the Parallel Coordinator is Running
|
|
SQL_TEXT
|
VARCHAR2(1000)
|
|
The resumable statement, selected from the V$SQL view.
|
|
NAME
|
VARCHAR2(4000)
|
|
The name given in the resumable clause of this resumable statement.
|
|
STATUS
|
VARCHAR2(16)
|
|
The status of the resumable statement. Its value can be one of RUNNING, SUSPENDED, ABORTED, ABORTING, TIMEOUT
|
|
ERROR_NUMBER
|
NUMBER
|
|
The error code of the last correctable error. When STATUS is equal to RUNNING, its value will be set to 0.
|
|
ERROR_MSG
|
VARCHAR2(4000)
|
|
The error message corresponding to ERROR_NUMBER. It will be set to NULL when ERROR_NUMBER is NULL.
|
|
ERROR_PARAMETER1
|
VARCHAR2(80)
|
|
The first parameter for the error message. NULL if no error.
|
|
ERROR_PARAMETER2
|
VARCHAR2(80)
|
|
The second parameter for the error message. NULL if no error.
|
|
ERROR_PARAMETER3
|
VARCHAR2(80)
|
|
The third parameter for the error message. NULL if no error.
|
|
ERROR_PARAMETER4
|
VARCHAR2(80)
|
|
The forth parameter for the error message. NULL if no error.
|
|
ERROR_PARAMETER5
|
VARCHAR2(80)
|
|
The fifth parameter for the error message. NULL if no error.
|
|
START_TIME
|
DATE
|
|
The start local time of the resumable statement.
|
|
SUSPEND_TIME
|
DATE
|
|
The last local time when the resumable statement was suspended. It is initialized to NULL.
|
|
RESUME_TIME
|
DATE
|
|
The last local time when the suspended resumable statement is resumed. It is initialized to NULL.
|
|
TIMEOUT
|
NUMBER
|
|
Timeout of the resumable statement
|
