Re: disk activity when no users/transactions

no jobs, tasks, processes etc... 8.1.6 on NT 4.0 SP6 512 mb RAM, PIII 500. disk activity stops when Oracle instance is shut down;

this also happens with any brand new/default instance/database creation, so there might be an issue with some default parameters or as Adrian mentioned, with the control file refresh.

I'll do some more testing....

thanks much,

In article <8ntv3h$bif$1_at_nnrp1.deja.com>,   Mark D Powell <markp7832_at_my-deja.com> wrote:
> 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
> >
> What OS and version of Oracle are you running? Are you sure it is
> Oracle and not the OS accessing the disk?
>
> Have you verified that no task or job is being ran from cron or
> dbms_job? Verified that exp, hot backups, and/or rman are not being
> ran?
>
> The only Oracle process that I can think of that runs every 3 seconds
> is log writer which will wake up and write the log buffer every 3
> seconds if the first two triggering events have not occurred in the
> last 3 seconds, but if no updates have been done I do not think Oracle
> would need to write the buffer.
>
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 22 2000 - 11:09:28 CDT