Re: 8i v. 9i?: Log_Checkpoint Timeout & Interval...

Okay, thank you for this info! I'm gonna leave the LOG_CHECKPOINT info out (it's not overly important that I include it); but I'm grateful for the opportunity to learn... ;)

Noel

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7c3cc$84p$1_at_lust.ihug.co.nz>...
> You can certainly add them... though one questions whether you should. 9i
> introduces a new parameter, called FAST_START_MTTR_TARGET (measured in the
> number of seconds you would like an Instance Recovery to finish in). That
> gets converted into settings for fast_start_io_target *and*
> log_checkpoint_interval. But if you set your own _interval, then the new
> parameter can't do its job.
>
> Then there's the question of whether you should set *any* of these
> parameters: all of them work by inducing additional checkpoints.
> Checkpoints mean I/O. I/O means slower performance.
>
> If you do decide to add them in, stick 'em in anywhere. There is no
> significance to the order of parameters within the init.ora. Just be
> warned: if you happen to be starting up using an spfile, then editing the
> init.ora has no effect until you force a startup to use it. Once started up
> with the init.ora, however, you can 'create spfile from pfile', and all
> subsequent spfile startups (the default) will know of your settings
> adjustments.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Noel Whelan" <nwhelan_at_wi.rr.com> wrote in message
> news:8915bac2.0203201342.4bde2df8_at_posting.google.com...
> > In 9i, the init.ora file I've got includes no LOG_CHECKPOINT_TIMEOUT
> > or LOG_CHECKPOINT_INTERVAL info. Is it okay if I insert this
> > information on my own? If it is, where in the file ought it to
> > go...&/or, if not, where is the info otherwise in 9i (the instructions
> > I've got to open the init.ora file & look for this info is for 8i).
> > Thank you,
> >
> > Noel Whelan
Received on Fri Mar 22 2002 - 18:40:55 CST