RE: Frequency of Log Switches

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Thu, 30 Nov 2000 10:26:25 -0800
Message-Id: <10696.123340@fatcity.com>

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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Frequency of Log Switches</TITLE>
</HEAD>
<BODY>

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 

<UL>
-----Original Message-----
 From:   SAURY Alain =
[SMTP:ASAURY_at_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=A0: I am running 8.1.6 =
on NT with log_checkpoint_timeout =3D 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).=20


Anybody having an idea on how to force =
a log switch=A0? 
Alain. =
Received on Thu Nov 30 2000 - 12:26:25 CST