Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: 8i v. 9i?: Log_Checkpoint Timeout & Interval...

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

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 21 Mar 2002 18:49:50 +1100
Message-ID: <a7c3cc$84p$1@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 Thu Mar 21 2002 - 01:49:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US