V$THREAD

V$THREAD displays thread information from the control file.

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

Note:

1.

select * from V$THREAD;

THREAD#

STATUS

ENABLED

GROUPS

INSTANCE

OPEN_ TIME

CURRENT_ GROUP#

SEQUENCE#

CHECKPOINT_ CHANGE#

CHECKPOINT_ TIME

ENABLE_ CHANGE#

ENABLE_ TIME

LAST_ REDO_ SEQUENCE#

LAST_ REDO_ BLOCK

LAST_ REDO_ CHANGE#

LAST_ REDO_ TIME

1

OPEN

PUBLIC

6

MYDB

2008-06-29 8:42:42 AM

3

377084

9665376080777

2008-08-28 9:35:46 AM

2202288276481

2003-09-21 7:21:30 AM

377084

389624

9665376110137

2008-08-28 9:37:32 AM

Oracle data dictionary views

Oracle dynamic performance views