Re: Control files are updated constantly

I've noticed this too - I used to think that there isn't heavy I/O on the controlfiles but checking with filemon on AIX it turned out that controlfiles
DO get hit with massive I/O !!! I still don't understand what the I/O is about, except for some checkpointing, but still ... maybe someone can clarify this ???

Knowing this - I never use more than 2 controlfiles (throw away that third one create by oracle ... don't need more I/O) and I never put them on the same disks
as system and redologs ...

"Orlando Amador" <oamador_at_psgapr.jnj.com> wrote in message news:6e75aa9.0203121033.1401091f_at_posting.google.com...
> Using a file monitoring tool from www.sysinternals.com it looks like
> the database control files are being updated every 2 o 3 seconds. The
> database is fairly small and other files like redo, or data files are
> not being updated that frequently.
>
> Is it normal for oracle.exe to write every few seconds to control
> files?
> Is this adjustable?
>
> Saludos,
>
> Orlando M. Amador
> Ortho Biologics LLC
> Sr. System Analyst
> oamador_at_psgapr.jnj.com
Received on Tue Mar 12 2002 - 13:36:57 CST