Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Library
Product
Contents
Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 87 of 179

V$LOGHIST

This view contains log history information from the control file. This view is retained for historical compatibility. Use of V$LOG_HISTORY is recommended 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 

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index