Well, speaking personally, I'd set log_checkpoint_timeout to zero. It's a
hideous parameter that has no more right to be set in a good init.ora than a
Priest has a right to make midnight visits to the local Convent.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
<dominica_at_secondhat.com> wrote in message
news:a7gfuk$la7$1_at_secondhat.secondhat.com...
> Hi All,
>
> I have an interesting thing happen to control file.
>
> I am running oracle 8.1.7.2 64 bits on solaris 2.8.
>
> This is just TEST machine and I notice all my
> 3 control files' time stamp get update all the time.
>
> Look at the following:
>
> -rw-r----- 1 oracle dba 2973696 Mar 22 15:41 control02.ctl
>
> almost every minute get updated.
>
> -rw-r----- 1 oracle dba 2973696 Mar 22 15:42 control02.ctl
>
> No one is using that oracle server, and the first time I am thinking about
> is checkpoint..
> Basically there is NO oracle activity by oracle user in that machine.
> I know oracle probably update the controlfile every now and then,
> BUT SHOULD the control file get updated per MINUTE this is my question
????
>
> then I look:
>
> SVRMGR> show parameters check
> NAME TYPE VALUE
> ----------------------------------- ------- ------------------------------
> db_block_checking boolean FALSE
> db_block_checksum boolean FALSE
> log_checkpoint_interval integer 99999999
> log_checkpoint_timeout integer 1800
> log_checkpoints_to_alert boolean FALSE
>
> I am wonder whether there is something else I should set,
> then the oracle won't update the controlfile that often or
> that is IT, the way Oracle work??
>
> Thanks in advance,
>
>
>
>
> Dominica
>
> dominica_at_secondhat.com
>
>
>
>
Received on Fri Mar 22 2002 - 18:46:06 CST
