From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: NT PERFMON Answer and question
Date: Fri, 2 Feb 2001 09:12:35 -0000
Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom
Lines: 53
Message-ID: <95dtm4$d1u$1@soap.pipex.net>
References: <95chdb$561@NWNEWS.PCT.EDU> <95cnmp$gph75$1@ID-56141.news.dfncis.de>
NNTP-Posting-Host: host9.audit-commission.gov.uk
X-Trace: soap.pipex.net 981105156 13374 193.128.236.219 (2 Feb 2001 09:12:36 GMT)
X-Complaints-To: abuse@uk.uu.net
NNTP-Posting-Date: 2 Feb 2001 09:12:36 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


Oracle 8i writes to disk every 3 seconds - it is the DBWR process that does
this.

Contrary to your response Perfmon *will* monitor disk io. This functionality
is disabled by default. What the original poster needs to do is run a
command prompt and type diskperf -y. This will enable the disk performance
counters after a reboot.

HTH


--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Harald Henkel" <Harald@Henkel.DAH.UUnet.DE> wrote in message
news:95cnmp$gph75$1@ID-56141.news.dfncis.de...
> Hi Scott.
>
> "Scott Watson" <swatson@datachest.com> schrieb im Newsbeitrag
> news:95chdb$561@NWNEWS.PCT.EDU...
> > I am trying to use NT perfmon to monitor what is going on at the OS
 level
> > and no matter what disk IO statistic I use it is always shows no IO (0
> > reads/writes).  (Even when I create a 400 Meg index)
> >
> > Can someone please let me know what I am doing wrong  NT4 SP6
>
> Nothing (PerfMon won't do the trick) -
> beside not using DiskMon or FileMon from www.sysinternals.com
>
> It (FileMon) showed me, that Oracle writes to its control files
 ctl1orcl.ora
> and ctl2orcl.ora every 3 seconds on one Oracle 8.1.6.3 installation - for
 no
> obvious reason (since the DB isn't doing much at the moment).
>
> Anybody has an idea what might be going on ?
> (it's WinNT 4 SP5)
>
> Can this be some installation / configuration problem ?
>
> It really looks like a configured interval. It's not "about" every 3
> seconds - it's exactly 3 seconds as far as I can see.
> Where would I configure this ?
>
> Ciao,
> Harald
>
>
>