Re: Oracle update controlfile every minute??

Hi,

From memory I think this is actually something to do with the way the Oracle code is written, it's the part of the code that would be getting used if you had an OPS (Oracle Parallel Server)environment setup. Oracle actualy syncs the control files every x seconds, I was actually under the impression it was normally every 3 seconds but never mind. This is nothing to be concerned about and is quite normal. I think the part of the code that does this is generic and thus applies even when not using an OPS environmet.

Daniel...

<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 - 21:01:49 CST