Re: AWR and I/O

   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-l