Re: Control files are updated constantly

koert54 wrote:
>
> 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

The ckpt process updates the control file every 3 seconds with checkpoint pointer information.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."