Re: Permanent disk writing

My LOG_CHECKPOINT_INTERVAL is set to 10000 and there is no "DBWR checkpoints" activity.

After a test on several days without any activity, only the following statistics move:
19: background timeouts: +1 per second
40: physical reads: +1 per 10 seconds

Anyone an idea on these disk accesses ?

--
Regards
Michel

Jurij Modic <jmodic_at_src.si> a écrit dans le message : 38184b50.3082320_at_news.siol.net...
> On Wed, 27 Oct 1999 14:35:30 GMT, akats53_at_my-deja.com wrote:
>
> >The DBWR normally writes every 3 seconds (time out).
> >So does the LGWR and neither one depends on fact whether or not you
> >have any activities
>
> Yes, but if there is no activity in the database, there could be no
> changes in the log buffers and database buffers, so LGWR and DBWR
> should have nothing to write to disks! I would be highly suspicious
> about disk lights flashing every second on an idle database server....
>
> So if there aren't any extremely frequent periodical dbms_jobs
> starting every second (very unlikely) I would check the frequency of
> checkpoints in the database. Look for "DBWR checkpoints" statistics in
> V$SYSSTAT. If I'm not mistaken, there were releases where setting
> LOG_CHECKPOINT_INTERVAL to 0 could cause extremely frequent
> checkpoints.
>
> HTH,
> Jurij Modic <jmodic_at_src.si>
> Certified Oracle DBA (7.3 & 8.0 OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
Received on Tue Nov 02 1999 - 05:01:25 CST