Date: Thu, 22 May 2008 09:01:19 -0700 (PDT)
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 .
> 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