Re: Mysterious disk activity

John wrote:
>
> This all makes sense to me. My problem is I cant find a way to diasable or
> extend the time period for the checkpoint process.
>
> The Oracle docs tell me to use "CHECKPOINT_PROCESS=FALSE" in the init.ora
> file, but on startup, the DB tells me that "CHECKPOINT_PROCESS" is an
> invalid parameter. I get the same result when changing the configuration
> using the oracle instance manager.
>
> Any other Ideas ?
>
> Oracle lover/hater:
> John
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:934kq3$2df$1_at_soap.pipex.net...
> > "Jining Han" <hanj_at_mailcity.com> wrote in message
> > news:932pr5$1an$1_at_nnrp1.deja.com...
> > > In article <4f456.5885$fC1.38853_at_nnrp1.ptd.net>,
> > > "John" <john_nospam_at_tolltex.com> wrote:
> > > > I have an Oracle 8 DB installed on an NT-Server and with no sessions
 open,
> > > > the database accesses the disk about every three seconds. I have
 loked
> > > > everywhere I can think of to find what is causing this but have come
 up dry.
> > > >
> > > > Any ideas ?.
> > > >
> > > > Thanks in advance
> > > > John
> > > >
> > > >
> > >
> > > 'Cause it's NT:)
> >
> > Reproducible on Unix,VMS etc as well. By default the DB will checkpoint
> > every 3 seconds.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> >
> >

Why worry about it ?

One tiny I/O every three seconds will pale into insignficance once your database starts getting used in earnest...

HTH
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

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