THREAD# |
NUMBER |
Thread number |
STATUS |
VARCHAR2 |
Thread status (OPEN | CLOSED ) |
ENABLED |
VARCHAR2 |
Enabled status: DISABLED , (enabled) PRIVATE , or (enabled) PUBLIC |
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 |
GROUPS |
NUMBER |
Number of log groups assigned to this thread |
INSTANCE |
VARCHAR2 |
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 |