checkpoint_process is an obsolete parameter (v7.3 IIRC). There are a couple
of settings you can change
log_checkpoint_interval and log_checkpoint_timeout. From what you say I
would hazard a guess that the docs you have do not relate to the oracle
version which you are running. I would strongly advise you to install the
appropriate docs on your workstation. As you have found system parameters
can and do change from revision to revision LOG_ARCHIVE_DEST is another that
springs to mind.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"John" <john_nospam_at_tolltex.com> wrote in message
news:wpm56.7425$fC1.53021_at_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:48:13 CST
