Re: two entries in initSID.ora for log_checkpoint

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 10 Dec 2002 19:12:56 +1100
Message-ID: <sdhJ9.267$jM5.1097@newsfeeds.bigpond.com>

In the case of duplicated init.ora parameters, it's always the second one that takes effect.

In the case of triplication, quadriplication or quintuplication (etc etc), it's always the last one in the file that takes effect.

Regards
HJR "Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0212092033.7c4339b2_at_posting.google.com...
> My colleague made a mistake he changed the value for
> log_checkpoint_interval. He add a new line and forgot to comment out
> the old line. In this case, which value is the effective one?
> This is what I see currently:
>
> SQL> show parameter log_chec
>
> NAME TYPE VALUE
> ------------------------------------ -------
> ------------------------------
> log_checkpoint_interval integer 11000, 55000
> log_checkpoint_timeout integer 0
> log_checkpoints_to_alert boolean FALSE
>
> Oracle 8.1.7.3
>
> rgds
> Daud
Received on Tue Dec 10 2002 - 02:12:56 CST

Re: two entries in initSID.ora for log_checkpoint_interval