V$LOGHIST contains log history information from the control file. This view is retained for historical compatibility. Oracle recommends that you use V$LOG_HISTORY instead.
See Also:
"V$LOG_HISTORY"| Column | Datatype | Description |
|---|---|---|
THREAD# |
NUMBER |
Log thread number |
SEQUENCE# |
NUMBER |
Log sequence number |
FIRST_CHANGE# |
NUMBER |
Lowest SCN in the log |
FIRST_TIME |
DATE |
Time of first SCN in the log |
SWITCH_CHANGE# |
NUMBER |
SCN at which the log switch occurred; one more than highest SCN in the log |