Re: AWR and I/O
From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Wed, 13 May 2009 10:58:38 -0500
Message-ID: <203315c10905130858t38748d66tbffdd5bb6935a18c_at_mail.gmail.com>
Adi
Date: Wed, 13 May 2009 10:58:38 -0500
Message-ID: <203315c10905130858t38748d66tbffdd5bb6935a18c_at_mail.gmail.com>
Adi
Yes, it is coming from v$filestat. Following is the SQL printing avg read call. stats$filestatxs is populated from STATS$V_$FILESTATXS view. fs.readtim is the column and fs is v$filestat.
select e.tsname
, sum (e.phyrds - nvl(b.phyrds,0)) reads .. , decode( sum(e.phyrds - nvl(b.phyrds,0)) , 0, 0 , (sum(e.readtim - nvl(b.readtim,0)) / sum(e.phyrds - nvl(b.phyrds,0)))*10) atpr ..... from stats$filestatxs e , stats$filestatxs b where b.snap_id(+) = :bid and e.snap_id = :eid and b.dbid(+) = :dbid and e.dbid = :dbid and b.dbid(+) = e.dbid and b.instance_number(+) = :inst_num and e.instance_number = :inst_num and b.instance_number(+) = e.instance_number and b.tsname(+) = e.tsname and b.filename(+) = e.filename and ( (e.phyrds - nvl(b.phyrds,0) ) + (e.phywrts - nvl(b.phywrts,0) ) ) > 0
Cheers
Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com
Specialists in Performance, Recovery and EBS11i
Blog: http://orainternals.wordpress.com
On Wed, May 13, 2009 at 1:16 AM, Adi Hirschtein <adi_at_zettapoint.com> wrote:
> Hi,
> > > > Got a question regarding the I/O section in the AWR report: > > Does anybody know where Oracle takes the Av Rd (ms) from? > > I've seen some articles saying that the source is avgiotim in the > v$filestat but when I checked it, it looks like it's always zero. > > > > Thanks, > > Adi > > > > Adi Hirschtein > VP, Product management > Zettapoint > 6 Hamasger Or Yehuda > Mobile (US): 978-201-2016 > Mobile: (ISL) +972-54-3033696 > Tel: (ISL) +972-3-6344718 > adi_at_zettapoint.com > www.zettapoint.com > > >
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 13 2009 - 10:58:38 CDT