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

[Noel Whelan]

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

[Connor McDonald]

They are still there - they just default to "intelligent" values. This
is part of Oracle's drive to make the config simpler. You can add them
to the standard init.ora file or your spfile.

Note that these parameters changed meaning in 8.1 (as compared to
previous versions)

hth
connor
--
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

[Howard J. Rogers]

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" <nwh...@wi.rr.com> wrote in message
news:8915bac2.02032...@posting.google.com...

[Noel Whelan]

Ok, good. The instructions I've got indicate ver. 8.1.6; & I'd guess
it's not gonna be an issue. In the init.ora file I've got (for 9i),
where is it I ought to insert this information?

Connor McDonald <connor_...@yahoo.com> wrote in message news:<3C9905...@yahoo.com>...

[Noel Whelan]

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" <d...@hjrdba.com> wrote in message news:<a7c3cc$84p$1...@lust.ihug.co.nz>...