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

Home -> Community -> Usenet -> c.d.o.server -> two entries in initSID.ora for log_checkpoint_interval

two entries in initSID.ora for log_checkpoint_interval

From: Daud <daud11_at_hotmail.com>
Date: 9 Dec 2002 20:33:02 -0800
Message-ID: <f0bf3cc3.0212092033.7c4339b2@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 Mon Dec 09 2002 - 22:33:02 CST

Original text of this message

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