Hey Ron.... I believe the name of that init parameter is
LOG_CHECKPOINTS_TO_ALERT (notice the "S") and it will record checkpoints
in the alert file. Someone correct me if I'm wrong. Another way to get
some ideas about your checkpoints is v$sysstat.
Keep in mind however a checkpoint can occur without a log switch but not
vice-versa. A log switch has an implicit checkpoint within it, but if
you have checkpoints between log switches you will get more checkpoints in
your alert file than log switches.
HTH,
John Dailey
Corporate Systems DBA
& All-Around Nice Guy
"Ron Perrie"
<ron.perrie@m To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
ci.co.uk> cc:
Sent by: Subject: init<sid>.ora problem
root@fatcity.
com
06/07/2001
10:07 AM
Please
respond to
ORACLE-L
--------------Boundary-00=_TQ9KG6G0000000000000
Content-Type: Text/Plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi List,
(SunOS 5.7, Oracle 8.1.6,Newbie DBA)
I have been reading Oracle DBA 101 and have come accross an init<sid>.ora=
parameter
"log_checkpoint_to_alert". I believe that once this parameter is set, the=
alert log will be fed with
information about log switches.
I have applied this parameter (log_checkpoint_to_alert =3D true ) and bou=
nced our database but it will now not startup unless I remove this parame=
ter.
The error message I get is "LRM-00101: unknown parameter name 'log_checkp=
oint_to_alert'".
Could any kind soul please enlighten me ?
Thanks,
Ron
--------------Boundary-00=_TQ9KG6G0000000000000
Content-Type: Text/HTML;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-885=
9-1"><html>
<head>
<meta name=3D"GENERATOR" content=3D"IncrediMail 1.0">
</head>
<BODY background=3D"" bgColor=3D#ffffff style=3D"BACKGROUND-POSITION: 0px=
0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial" scroll=3Dyes ORGY=
POS=3D"0">
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w=
idth=3D"95%">
<TR>
<TD id=3DINCREDITEXTREGION width=3D"100%" style=3D"PADDING-RIGHT: 7px; PA=
DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial"=20
>
<DIV>Hi List,</DIV>
<DIV> </DIV>
<DIV>(SunOS 5.7, Oracle 8.1.6,Newbie DBA)</DIV>
<DIV> </DIV>
<DIV>I have been reading Oracle DBA 101 and have come accross an=20
init<sid>.ora parameter</DIV>
<DIV>"log_checkpoint_to_alert". I believe that once this parameter =
is set,=20
the alert log will be fed with</DIV>
<DIV>information about log switches.</DIV>
<DIV>I have applied this parameter (log_checkpoint_to_alert =3D tru=
e ) and=20
bounced our database but it will now not startup unless I remove th=
is=20
parameter.</DIV>
<DIV>The error message I get is "LRM-00101: unknown parameter name=20
'log_checkpoint_to_alert'".</DIV>
<DIV> </DIV>
<DIV>Could any kind soul please enlighten me ?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV> </DIV>
<DIV>Ron</DIV></TD>
</TR>
<TR>
<TD id=3DINCREDIFOOTER width=3D"100%">
=09<TABLE cellPadding=3D0 cellSpacing=3D0 width=3D"100%">
=09<TR>
=09<TD width=3D"100%"></TD>
=09<TD align=3Dmiddle id=3DINCREDISOUND vAlign=3Dbottom></TD>
=09<TD align=3Dmiddle id=3DINCREDIANIM vAlign=3Dbottom></TD>
=09</TR>
=09</TABLE>
</TD>
</TR>
</TABLE><SPAN=20
id=3DIncrediStamp>
<P align=3Dleft><FONT face=3D"Arial, Helvetica, sans-serif"=20
size=3D2>__________________________________________________<BR><FONT=20
face=3D"Comic Sans MS" size=3D2><I>IncrediMail</I> - <B>Email has finally=
=20
evolved</B> - </FONT><A href=3D"http://www.incredimail.com/imstamp26.html=
"><FONT=20
face=3D"Times New Roman" size=3D3><B><U>Click=20
Here</U></B></FONT></A></P></SPAN></FONT>
</BODY>
</html>
--------------Boundary-00=_TQ9KG6G0000000000000--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Perrie
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).