V$LOGHIST

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