Re: disk activity when no users/transactions

just wanted to take the time and thank you and all other great people on this forum for taking time out of their day to help others. You guys do a fantastic job!!!

now, back to the drawing board: I've gone through **all suggestions** given in all the posts in my thread and no luck. Now, this _db_block_no_idle_writes=true may be the closest to solving the issue, although I'm not sure if this parameter is supported in Ora 8i (8.1.6) as, when I introduce it in the param file I get:

LRM-00101: unknown parameter name 'db_block_no_idle_writes' ORA-01078: failure in processing system parameters

are there any other switches or registry thingies that I should be looking into!? I have plenty memory and no paging is occuring.

I even created a vanilla database (from scratch, no data on it other than what's built by Oracle) and only started this instance and I am still getting this disk annoying access every 3 seconds. Let me clarify: I get two consecutive very short disk accesses every 3 seconds.

PS. I posted my system hardware and software in the last post of this thread.

thanks much,

Cosmin

In article <966978491.6788.1.nnrp-09.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> DBWR has (user to have) an idle-write
> every 3 seconds that ensured that the
> SGA became clean when the database
> went quiet. This sounds as if it may
> be consistent with the observations.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Mark D Powell wrote in message <8ntv3h$bif$1_at_nnrp1.deja.com>...
> >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 - 22:14:17 CDT