Re: Oracle won't relax when not being used.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3befdac8$0$236$ed9e5944_at_reading.news.pipex.net...
> From 8i DBWR writes a checkpoint every 3 seconds. This is normal
behaviour.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission Uk
> <johnt_at_tman.dnsalias.com> wrote in message
> news:gvQH7.3090$lY5.2302894_at_newssvr28.news.prodigy.com...
> > Hi, I have an aggravation w Oracle 901 on SUSE Linux 7.2. Basically,
> > when the instance is running, it decides to write to the disk every
> > 3-4 seconds. vmstat tells me it is writing about 10-20 blocks. I
> > can tell that this is Oracle cause it doesn't happen when I shut down
> > the server.
> >
> > This happens even if there are no clients connected. Matter of fact,
> > I started up Oracle, the 3-second writes started, and continued for
> > over 24 hours (to this point). During this time-frame, not a single
> > client connected.
> >
> > So it is not a huge deal, but these writes to disk must be flushing
> > through buffer, because every write creates an audible click from the
> > hard drive. It is like my hard drive is clicking to time when Oracle
> > is running.
> >
> > If it matters, the server has 756M RAM, max pool used by Oracle is
> > about 500M, and it makes extensive use of raw I/O, e.g. /dev/raw/...
> >
> > Any ideas what Orcle is doing and if it can/ should be fixed?
> >
> > Thanks,
> > JT.
> >
> >
> >
>
>

Also the OP is devoting 500 out of 756 M to the SGA, so he must have excessive paging.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address