[Home] [Help] [Dependency Information]
Object Name: | V_$CELL_OFL_THREAD_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CELL_NAME | VARCHAR2 | (1024) | ||
GROUP_NAME | VARCHAR2 | (1024) | ||
PROCESS_ID | NUMBER | |||
SNAPSHOT_ID | NUMBER | |||
SNAPSHOT_TIME | DATE | |||
THREAD_ID | NUMBER | |||
JOB_TYPE | VARCHAR2 | (32) | ||
WAIT_STATE | VARCHAR2 | (32) | ||
WAIT_OBJECT_NAME | VARCHAR2 | (32) | ||
SQL_ID | VARCHAR2 | (13) | ||
DATABASE_ID | NUMBER | |||
INSTANCE_ID | NUMBER | |||
SESSION_ID | NUMBER | |||
SESSION_SERIAL_NUM | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CELL_NAME
, GROUP_NAME
, PROCESS_ID
, SNAPSHOT_ID
, SNAPSHOT_TIME
, THREAD_ID
, JOB_TYPE
, WAIT_STATE
, WAIT_OBJECT_NAME
, SQL_ID
, DATABASE_ID
, INSTANCE_ID
, SESSION_ID
, SESSION_SERIAL_NUM
, CON_ID
FROM SYS.V_$CELL_OFL_THREAD_HISTORY;
|
|
|