From John.Dailey@ing-fsi-na.com Thu, 07 Jun 2001 09:53:50 -0700 From: John.Dailey@ing-fsi-na.com Date: Thu, 07 Jun 2001 09:53:50 -0700 Subject: Re: init.ora problem Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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" ci.co.uk> cc: Sent by: Subject: init.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.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
Hi List,
 
(SunOS 5.7, Oracle 8.1.6,Newbie DBA)
 
I have been reading Oracle DBA 101 and have come accross an=20 init<sid>.ora parameter
"log_checkpoint_to_alert". I believe that once this parameter = is set,=20 the alert log will be fed with
information about log switches.
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.
The error message I get is "LRM-00101: unknown parameter name=20 'log_checkpoint_to_alert'".
 
Could any kind soul please enlighten me ?
 
Thanks,
 
Ron
=09 =09 =09 =09 =09 =09 =09

__________________________________________________
IncrediMail - Email has finally= =20 evolved - Click=20 Here

--------------Boundary-00=_TQ9KG6G0000000000000-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Perrie INET: ron.perrie@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@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@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@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).