Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$LOG_HISTORY on 7.3.4, Q on SQL&PL/SQL Annotated Archives book
20-30 minutes is a good rule of thumb.
On my VMS boxes, v$loghist contains 1600 rows, while on unix it has 100 rows. Maybe it's os dependent?
Andy Hardy wrote:
> 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 - 11:25:31 CST