Re: disk activity when no users/transactions

I remember a thread on an Oracle DBA list that may be relevant to your problem. When you say the CHECKPOINT PROCESS, do you mean CKPT or DBWRn? Are you sure the disk activity is every second rather than every 3 seconds? If it's CKPT and it's every 3 seconds, it has a what Oracle calls heartbeat mechanism for the CKPT timeout action, beginning with Oracle 8.0.5. It's not really checkpointing. Steve Adams says it's just 'rdbms ipc message'.

You can find a lot of articles on metalink talking about this.

Yong Huang
yhuang_at_indigopool.com

Silvio Seifert <silvio.seifert_at_gmx.net> wrote in message news:8orhj6$aiu$16$1_at_news.t-online.com...
> On Tue, 22 Aug 2000 16:04:55 GMT, Cosmin Ioan
> <cosmin_ioan_at_my-deja.com> wrote:
>
> We have the same situation on Solaris 2.7, Oracle 8i.
> No memory shortage, check point interval and timeout set as in
> previous Oracle version, no database activities at all, no users apart
> from me on system.
>
> Nevertheless, about every second some disk activity.
>
> Using truss and lsof, I examined all Oracle background processes.
>
> It's definitely the CHECKPOINT PROCESS, which accesses the
> controlfiles every second.
>
> Is there a way to change this intervall ?
>
> Regards
>
> >thanks for all great responsens everbody....
> >I guess, now I have a bit of testing/checking to do .... :-)
> >again, thanks
> >
> >PS. I have 8.1.6 on NT 4.0 SP6. w/ 512 Mb Ram, PIII 500, and
> >plenty 'available' RAM, although yes, the whole database (and Ora
> >files) are on a single SCSI disk which I will change in the near
> >future. I am aware of the spread of different tablespaces on multiple
> >disks and 'am working on it' however this is just a test machine that
> >I'm using at home and as such, had not allocated the proper hardware.
> >Oracle runs pretty fast, although the Java management tools are awfully
> >slow on my machine. I probably need to get a 1 Ghz machine :-) <g>
> >
> >
> >
> >
> >
> >In article <8nsq04$2re$1_at_nnrp1.deja.com>,
> > cosmin_ioan_at_my-deja.com wrote:
> >> hello all,
> >>
> >> I'm trying to troubleshoot and eliminate or at least, increase the
> >> interval at which the harddrive is accessed when absolutely no users
 or
> >> transactions are running on the server. Basically, the drive is
> >> accessed about every 3 seconds (or so) and I believe it has to do with
> >> the checkpoint process or some other oracle process. Could anybody
> >> shed some light on how I can reduce/eliminate disk access when the
> >> database is in no use (other than shutting down the instance, which
> >> yes, eliminates all further disk accesses)
> >>
> >> thanks much,
> >>
> >> Cosmin
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Before you buy.
> >>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>
> Silvio Seifert
> Foehrer Strasse 34
> 65199 Wiesbaden
> Germany
Received on Tue Sep 05 2000 - 13:31:11 CDT