Re: Mysterious disk activity

From: John <john_nospam_at_tolltex.com>
Date: Fri, 05 Jan 2001 16:14:20 GMT
Message-ID: <wpm56.7425$fC1.53021@nnrp1.ptd.net>

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

>
> Received on Fri Jan 05 2001 - 10:14:20 CST