Re: V$LOGHIST content cutoff criteria

The number of entries is stored inside the control file and its size is determined by MAXLOGHISTORY.

Use this option when creating the database or creating a control file. I believe that the default is 100 if you don't specify this (which most DBAs do not).

I explictly make MAXLOGHISTORY 4000 instead of the default of 100. It's definitely come in handy to be able to go way back in the past to see log switch history and costs nothing but a couple of extra kilobytes added on to the control file size.

I'm not sure why any of the Oracle 3rd party books mention this.

On Tue, 20 Jul 1999 16:10:46 +0100, "Kevin A Lewis" <KevinALewis_at_Hotmail.com> wrote:

>We have two databases one on 7.2.3 and one on 8.0.4
>
>The V$LOGHIST view reports back to 19 July 1999 on the version 7 database
>but back to April 1998 on the version 8. What might affect this difference
>and can it be affected.
>
>I mainly ask as all this extra data in the version 8 is far too old to be of
>real interest.
>
>Regards
Received on Tue Jul 20 1999 - 21:23:21 CDT