[Home] [Help] [Dependency Information]
Object Name: | V_$THREAD |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
THREAD# | NUMBER | |||
STATUS | VARCHAR2 | (6) | ||
ENABLED | VARCHAR2 | (8) | ||
GROUPS | NUMBER | |||
INSTANCE | VARCHAR2 | (80) | ||
OPEN_TIME | DATE | |||
CURRENT_GROUP# | NUMBER | |||
SEQUENCE# | NUMBER | |||
CHECKPOINT_CHANGE# | NUMBER | |||
CHECKPOINT_TIME | DATE | |||
ENABLE_CHANGE# | NUMBER | |||
ENABLE_TIME | DATE | |||
DISABLE_CHANGE# | NUMBER | |||
DISABLE_TIME | DATE | |||
LAST_REDO_SEQUENCE# | NUMBER | |||
LAST_REDO_BLOCK | NUMBER | |||
LAST_REDO_CHANGE# | NUMBER | |||
LAST_REDO_TIME | DATE | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT THREAD#
, STATUS
, ENABLED
, GROUPS
, INSTANCE
, OPEN_TIME
, CURRENT_GROUP#
, SEQUENCE#
, CHECKPOINT_CHANGE#
, CHECKPOINT_TIME
, ENABLE_CHANGE#
, ENABLE_TIME
, DISABLE_CHANGE#
, DISABLE_TIME
, LAST_REDO_SEQUENCE#
, LAST_REDO_BLOCK
, LAST_REDO_CHANGE#
, LAST_REDO_TIME
, CON_ID
FROM SYS.V_$THREAD;
|
|
|