I do have log_checkpoints_to_alert=true. The only checkpoints that
appear in alert.log are when a log switch occurs or alter system
checkpoint. Nothing for background checkpoints... is that normal??
Winnie_Liu_at_infonet.com wrote:
>
> Suzy,
>
> In order for Oracle to write the checkpoint to the alert.log. You will need
> to set this parameter up in the init.ora file.
>
> LOG_CHECKPOINTs_TO_ALERT=TRUE
>
> hth
>
> Winnie
>
> Suzy Vordos <lvordos_at_datsit.com>@fatcity.com on 01/04/2001 01:15:25 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
> Questioned this myself after noticing 8i logswitch checkpoints taking a
> LONG time. There is a new parameter you might look at:
> fast_start_io_target. Also look at v$instance_recovery, it shows which
> parameter (log_checkpoint_timeout, log_checkpoint_interval,
> fast_start_io_target) takes priority for controlling checkpoints.
>
> I ended up setting both log_checkpoint_timeout and
> log_checkpoint_interval to zero. Then fiddled with fast_start_io_target
> until the checkpoint intervals seemed reasonable. Note that these
> checkpoints don't appear in alert.log, I dunno why.
>
> Still bewildered, but things appear to be working much better....
> suzy
>
> > "Koivu, Lisa" wrote:
> >
> > hello all,
> >
> > I've got LOG_CHECKPOINT_TIMEOUT set to 1800 (30 minutes) in one of my
> > databases. I also have LOG_CHECKPOINTS_TO_ALERT set to true.
> > However, every morning I look at the archive logs and I see that 1.
> > the logs haven't switched since the nightly batch quit and 2. there
> > are no checkpoints in the alert log since the log switch. This makes
> > me a little nervous.
> >
> > It seems that LOG_CHECKPOINT_TIMEOUT is not working. However, I find
> > this on metalink that kind of explains it.
> >
> > The parameter log_checkpoint_timeout has been re-interpreted. In prior
> > releases, every log_checkpoint_timeout seconds, Oracle started an
> > interval checkpoint. Starting with Oracle 8.1, log_checkpoint_timeout
> > will be interpreted to mean that the incremental checkpoint should be
> > at the log position where the tail of the log was
> > log_checkpoint_timeout seconds ago. In other words, the incremental
> > checkpoint should lag the tail of the log by no more than
> > log_checkpoint_timeout seconds worth of redo.
> >
> > I don't quite understand. Can someone paraphrase this? Does this
> > mean that every LOG_CHECKPOINT_TIMEOUT seconds it makes sure that
> > there is no redo that hasn't been written to disk that is more than
> > LOG_CHECKPOINT_TIMEOUT seconds old? In other words, it checks to see
> > if a checkpoint is necessary instead of just doing it?
> >
> > Thanks
> >
> > Lisa Rutland Koivu
> > Oracle Database Administrator
> > Qode.com
> > 4850 North State Road 7
> > Suite G104
> > Fort Lauderdale, FL 33319
> >
> > V: 954.484.3191, x174
> > F: 954.484.2933
> > C: 954.658.5849
> > http://www.qode.com
> >
> > "The information contained herein does not express the opinion or
> > position of Qode.com and cannot be attributed to or made binding upon
> > Qode.com."
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suzy Vordos
> INET: lvordos_at_datsit.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Winnie_Liu_at_infonet.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
Received on Fri Jan 05 2001 - 13:11:47 CST
