Dynamic Performance (V$) Views, 92 of 179

V$LOG_HISTORY

This view contains log history information from the control file.

Column	Datatype	Description
`THREAD#`	`NUMBER`	Thread number of the archived log
`SEQUENCE#`	`NUMBER`	Sequence number of the archived log
`FIRST_TIME`	`DATE`	Time of first entry (lowest SCN) in the log. This column was previously named TIME
`FIRST_CHANGE#`	`NUMBER`	Lowest SCN in the log. This column was previously named LOW_CHANGE#
`NEXT_CHANGE#`	`NUMBER`	Highest SCN in the log. This column was previously named HIGH_CHANGE#
`RECID`	`NUMBER`	Control file record ID
`STAMP`	`NUMBER`	Control file record stamp