9.115 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 status ( |
|
|
Enabled status: |
|
|
Number of log groups assigned to this thread |
|
|
Instance name, if available |
|
|
Last time the thread was opened |
|
|
Current log group |
|
|
Sequence number of current log |
|
|
SCN at last checkpoint |
|
|
Time of last checkpoint |
|
|
SCN at which thread was enabled |
|
|
Time of enable SCN |
|
|
SCN at which thread was disabled |
|
|
Time of disable SCN |
|
|
Last redo sequence number written by LGWR |
|
|
Last redo block written by LGWR |
|
|
SCN of last redo for the thread |
|
|
Time of last redo for the thread |
|
|
The ID of the container to which the data pertains. Possible values include:
|