Message-Id: <10696.123340@fatcity.com> From: Satar Naghshineh Date: Thu, 30 Nov 2000 10:26:25 -0800 Subject: RE: Frequency of Log Switches This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C05AFB.119C9020 Content-Type: text/plain log_checkpoint_timeout issues a checkpoint, which does NOT switch the log file. However, a switch in a log file issues a checkpoint. If you are forcing checkpoints, I highly recommend that you do it by data rather than by time. "alter system switch logfile" (or is it alter database..., I have to RTFM) will switch the logfile. You could have this statement get issued via the at command. Regards, Satar > -----Original Message----- > From: SAURY Alain [SMTP:ASAURY@recherche.loreal.com] > Sent: Thursday, November 30, 2000 10:56 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Frequency of Log Switches > > I beg to differ : I am running 8.1.6 on NT with log_checkpoint_timeout = > 300 and can have as much as 40 minutes between log switches. > > I suppose that forcing a checkpoint does not forces a log switch (whereas > the log switch forces the checkpoint). > > Anybody having an idea on how to force a log switch ? > Alain. > > ------_=_NextPart_001_01C05AFB.119C9020 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Frequency of Log Switches

log_checkpoint_timeout issues a checkpoint, which does = NOT switch the log file. However, a switch in a log file issues a = checkpoint.

If you are forcing = checkpoints, I highly recommend that you do it by data rather than by = time.

"alter system = switch logfile" (or is it alter database..., I have to RTFM) will = switch the logfile. You could have this statement get issued via the at = command.

Regards,
Satar