Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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
Feedback

Go to previous page Go to next page
View PDF

V$THREAD

This view contains 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