Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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