| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: init<sid>.ora problem
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_at_m To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
ci.co.uk> cc:
Sent by: Subject: init<sid>.ora problem
root_at_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>
<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=20face=3D"Comic Sans MS" size=3D2><I>IncrediMail</I> - <B>Email has finally= =20
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Perrie INET: ron.perrie_at_mci.co.uk 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: ListGuru_at_fatcity.com (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: John.Dailey_at_ing-fsi-na.com 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: ListGuru_at_fatcity.com (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).Received on Thu Jun 07 2001 - 11:53:50 CDT
 |
 |