Re: v$log_history

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 2000/05/17
Message-ID: <20000517152121.07799.00000135@nso-md.aol.com>#1/1

In article <391C02EA.8E867CFB_at_Unforgettable.com>, Kenneth C Stahl <BlueSax_at_Unforgettable.com> writes:

>Apparently the structure of V$LOG_HISTORY has changed from V7.3 to 8i.
>The STAMP colum apparently replaces the TIME column. Does anyone know
>the appropriate to_date() mask for the STAMP column?
>

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   Controlfile record ID  
 
STAMP                  NUMBER   Controlfile record stamp  
 

Paul in VT Received on Wed May 17 2000 - 00:00:00 CDT