Re: AWR and I/O
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: adi@xxxxxxxxxxxxxx
- Date: Wed, 13 May 2009 10:58:38 -0500
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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx
> www.zettapoint.com
>
>
>
Other related posts:
- » AWR and I/O- Adi Hirschtein
- » Re: AWR and I/O - Riyaj Shamsudeen
