Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$THREAD

V$THREAD displays thread information from the control file. This view does not return meaningful results on a physical standby database.

Column Datatype Description
THREAD# NUMBER Thread number
STATUS VARCHAR2(6) Thread status (OPEN| CLOSED)
ENABLED VARCHAR2(8) Enabled status: DISABLED, (enabled) PRIVATE, or (enabled) PUBLIC
GROUPS NUMBER Number of log groups assigned to this thread
INSTANCE VARCHAR2(16) Instance name, if available
OPEN_TIME DATE Last time the thread was opened
CURRENT_GROUP# NUMBER Current log group
SEQUENCE# NUMBER Sequence number of current log
CHECKPOINT_CHANGE# NUMBER SCN at last checkpoint
CHECKPOINT_TIME DATE Time of last checkpoint
ENABLE_CHANGE# NUMBER SCN at which thread was enabled
ENABLE_TIME DATE Time of enable SCN
DISABLE_CHANGE# NUMBER SCN at which thread was disabled
DISABLE_TIME DATE Time of disable SCN
LAST_REDO_SEQUENCE# NUMBER Last redo sequence number written by LGWR
LAST_REDO_BLOCK NUMBER Last redo block written by LGWR
LAST_REDO_CHANGE# NUMBER SCN of last redo for the thread
LAST_REDO_TIME DATE Time of last redo for the thread