Re: Log Switching interval

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 8 Oct 1999 11:21:35 +0100
Message-ID: <939378150.1382.0.nnrp-02.9e984b29@news.demon.co.uk>

One option would be to get the code to look at v$sysstat for the latest value of 'redo size', and only force the switch if this had changed sufficiently since the last check.

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

Fred Dinage wrote in message <7tk8s8$rur$1_at_pheidippides.axion.bt.co.uk>...
>Is there any way in Oracle to check how much has been written to the log
>files. We want to switch the logs every 3 minutes for a hot standby setup
>and we are currently just issuing an "alter system switch logfile" command
>every 3 mins.Ideally we would only like to switch logs every 3 minutes when
>something has actually been written to the logs. How could we check this??
>
>Cheers
>
>Fred Dinage
>
>
>
Received on Fri Oct 08 1999 - 05:21:35 CDT