Oracle update controlfile every minute??

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 - 17:49:54 CST