Re: v$log_history

On May 22, 10:56 am, tim2bo..._at_gmail.com wrote:
> On May 22, 11:01 am, "Uwe Schmidt" <uwe.schm..._at_dataport.de> wrote:
>
> > Hy NG,
>
> > how long are the entries stored in the view v$log_history ?
> > I looked into 2 diffrent databases and saw diffrent entries; 1= 2weeks ***
> > 2=3month ??? Wher can i customize the time how long the entries are stored?
>
> > So long
> > Uwe
>
> I believe that these entries are based on the controlfile and the
> controlfile keep time is based on the initialization parameter
> CONTROL_FILE_RECORD_KEEP_TIME .
>
> Regards
> tim Boles

The redo log history is not controlled by that parameter, it is governed by the MAXLOGHISTORY setting. I've explained how to change this in a prior response.

David Fitzjarrell Received on Thu May 22 2008 - 11:01:19 CDT