[Home] [Help] [Dependency Information]
Object Name: | USER_RESUMABLE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Resumable session information for current user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Session ID of this resumable session | ||
INSTANCE_ID | NUMBER | Instance ID of this resumable session | ||
COORD_INSTANCE_ID | NUMBER | Instance number of parallel query coordinator | ||
COORD_SESSION_ID | NUMBER | Session number of parallel query coordinator | ||
STATUS | VARCHAR2 | (9) | Status of this resumable session | |
TIMEOUT | NUMBER | Timeout of this resumable session | ||
START_TIME | VARCHAR2 | (20) | Start time of the current transaction | |
SUSPEND_TIME | VARCHAR2 | (20) | Suspend time of the current statement | |
RESUME_TIME | VARCHAR2 | (20) | Resume time of the current statement | |
NAME | VARCHAR2 | (4000) | Name of this resumable session | |
SQL_TEXT | VARCHAR2 | (1000) | The current SQL text | |
ERROR_NUMBER | NUMBER | The current error number | ||
ERROR_PARAMETER1 | VARCHAR2 | (80) | The 1st parameter to the current error message | |
ERROR_PARAMETER2 | VARCHAR2 | (80) | The 2nd parameter to the current error message | |
ERROR_PARAMETER3 | VARCHAR2 | (80) | The 3rd parameter to the current error message | |
ERROR_PARAMETER4 | VARCHAR2 | (80) | The 4th parameter to the current error message | |
ERROR_PARAMETER5 | VARCHAR2 | (80) | The 5th parameter to the current error message | |
ERROR_MSG | VARCHAR2 | (4000) | The current error message |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, INSTANCE_ID
, COORD_INSTANCE_ID
, COORD_SESSION_ID
, STATUS
, TIMEOUT
, START_TIME
, SUSPEND_TIME
, RESUME_TIME
, NAME
, SQL_TEXT
, ERROR_NUMBER
, ERROR_PARAMETER1
, ERROR_PARAMETER2
, ERROR_PARAMETER3
, ERROR_PARAMETER4
, ERROR_PARAMETER5
, ERROR_MSG
FROM SYS.USER_RESUMABLE;
|
|
|