Re: Control files are updated constantly

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

yes ... that's normal - but what surprised me is that the I/O that's generated on controlfiles can sometimes be as high (and sometimes even more ) as I/O
on redologs. This was a bit surprising to me and I couldn't quite figure it out ... I doubt that updating checkpoint pointer information can generate 20MB worth
of I/O within one minute on the controlfile ? I'll search for the filemon output tomorow in the office ... just to make sure I'm talking rubbish here :-)

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3C8E6850.7419_at_yahoo.com...
> 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..."
Received on Tue Mar 12 2002 - 15:31:35 CST