Re: Log switching at a specific time interval

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Thu, 27 Sep 2001 01:13:43 +0100
Message-ID: <9otuu0$22c$1@phys-ma.sol.co.uk>

Look at log_checkpoint_timeout initialisation parameter.

ta
Lawrence

"Mark" <markag_at_wonderstats.com> wrote in message news:ba6d27ca.0109260910.458eef26_at_posting.google.com...
> Hi all,
>
> I want to force a log switch every 20 minutes at a minimum, or the
> normal event of the log filling - which ever comes first.
>
> Can I do that by setting some init.ora params or do I need to create a
> job that runs every 20 minutes that exec's ALTER SYSTEM SWITCH LOGFILE
> command?
>
> How do I do that?
>
> Oracle 8.1.5
Received on Wed Sep 26 2001 - 19:13:43 CDT