Av Rd(ms) in 11g show zero for AWR
654688Jun 8 2010 — edited Jun 8 2010I am looking at an upgraded database to 11g (11.2.0.1), and I am looking at the tablespace IO stats.
I always check these to see how the I/O is performing.. When I looked at that data on 11g, I see 0 ms ..
Anyone seen this and have any idea where to get the correct seek times ?? Also the buffer wait times for writes look too good to be true.
Tablespace IO Stats
ordered by IOs (Reads + Writes) desc
Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
UNDOTBS1 853,741 237 0.00 1.00 81,576 23 5 2.00
SPR__DT 361,972 100 0.00 3.96 23 3,098 65 0 0.00