Re: V$LOG_HISTORY on 7.3.4, Q on SQL&PL/SQL Annotated Archives book

The number depends on a database creation value which controls the size of the controlfile. Do a backup controlfile to trace and look at the value of MAXLOGHISTORY (or some such).

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Andy Hardy wrote in message ...
>Hello,
>
>I've just been browsing through Loney and Carmichaels book 'Oracle SQL &
>PLS/SQL Annotated Archives' from Osborne Press.
>
>The section that I'm looking at is about REDO logs and suggests that
>they should be switching no more frequently than every 20-30 minutes.
>The text and the piece of SQL to verify this state that the
>V$LOG_HISTORY view shows the last 100 log switches.
>
>This doesn't seem to match my db which has over 1600 switches in its
>v$log_history!
>
>So, what is the truth behind the view? And, is the 20-30 minute rule of
>thumb of practical use?
>
>Andy
>--
>Andy Hardy
>Senior IT Systems Engineer, Alstom Automation
>Tel: +44 1908 696200
>Fax: +44 1908 696225
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Opinions are mine and do not necessarily reflect those of Alstom Automation
Received on Wed Jan 20 1999 - 14:27:08 CST