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
|