daud11_at_hotmail.com (Daud) 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
From logical point of view (which may not be a true) I would suggest
that the lower one will be used. Because counter will be zeroed while
checkpoint occured and then next one will be while lower value would
equals number of system blocks written since, I think (again not know
for sure) that higher number can never be reached.
However, strange is that behaviour described by you, only occurs when
second value is on the line next to first one. If between these two
lines is for example log_checkpoint_timeout line, then only second
value will be used.
Oracle 8.1.7.1 EE WIN2000.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Tue Dec 10 2002 - 07:53:25 CST
