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" <NOhicamelSPAM_at_comcast.net> wrote in message
news:vdmFb.12034$VB2.21282_at_attbi_s51...
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:bs4p1v$go8$1$8300dec7_at_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
>
>
Received on Sun Dec 21 2003 - 15:33:26 CST
