Path: archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer01.lnd.ops.eu.uu.net!lnewsinpeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <niall.litchfi...@dial.pipex.com>
Newsgroups: comp.databases.oracle.server
References: <FB6Fb.167026$_M.759985@attbi_s54> <ZK6Fb.32237$BQ5.9627@fed1read03> <Ze8Fb.103426$8y1.317856@attbi_s52> <8t8Fb.32649$BQ5.21787@fed1read03> <J_8Fb.103585$8y1.319067@attbi_s52> <To9Fb.33100$BQ5.17333@fed1read03> <ez9Fb.446468$275.1320599@attbi_s53> <bs4p1v$go8$1$8300dec7@news.demon.co.uk> <vdmFb.12034$VB2.21282@attbi_s51>
Subject: Re: Background Processes and I/O
Date: Sun, 21 Dec 2003 21:33:26 -0000
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Lines: 43
Message-ID: <3fe61185$0$28696$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Date: 21 Dec 2003 21:32:53 GMT
NNTP-Posting-Host: 1Cust238.tnt107.lnd4.gbr.da.uu.net
X-Trace: 1072042373 news.dial.pipex.com 28696 213.116.62.238:3210
X-Complaints-To: abuse@uk.uu.net

I'm pretty sure, and I don't know how the question was phrased in your test,
but at 8i that the which processes do IO question seemed to regard only
writes as IO and not reads.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Michael J. Moore" <NOhicamelS...@comcast.net> wrote in message
news:vdmFb.12034$VB2.21282@attbi_s51...
>
> "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk> wrote in message
> news:bs4p1v$go8$1$8300dec7@news.demon.co.uk...
> >
> > Smon kicks in every 5 minutes to query ts$ to check
> > if any dictionary-managed tablespaces have pctincrease
> > non-zero, and then tries to coalesce them.  THere are several
> > other jobs that smon does which are also visible as standard
> > SQL querying, and therefore require normal database read
> > requests.
> >
> >
> > --
> > Regards
> >
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> >
> >
>
> So, is it fair to say that both SMON and PMON perform I/O?
> Regards,
> Mike
>
>