AWR REPORTS INCORRECT IO STATS FOR TABLESPACES AND DATAFILES (Doc ID 827104.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2.0 to 11.1.0.7.0
This problem can occur on any platform.

Symptoms

During RMAN backup AWR reports shows huge values - more than 100,000 ms -for "Av Rd(ms)" statistic on tablespaces and datafiles.

Example:
======

Tablespace IO Stats DB/Inst: P80/P80 Snaps: 4805-4806
-> ordered by IOs (Reads + Writes) desc
.
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PSAPSR3
75 0 ###### 2.2 673 0 1 0.0
PSAPSR3700
374 0 ###### 2.3 57 0 0 0.0
SYSAUX
2 0 ###### 1.0 223 0 0 0.0
PSAPUNDO
2 0 ###### 1.0 220 0 2 0.0
SYSTEM
2 0 ###### 1.0 81 0 0 0.0
PSAPSR3USR
2 0 ###### 1.0 2 0 0 0.0
-------------------------------------------------------------
.
File IO Stats DB/Inst: P80/P80 Snaps:
4805-4806
-> ordered by Tablespace, File
.
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PSAPSR3 /oracle/P80/sapdata10/sr3_1/sr3.data1
6 0 ###### 1.0 32 0 0 0.0
PSAPSR3 /oracle/P80/sapdata10/sr3_2/sr3.data2
15 0 ###### 2.2 63 0 0 0.0
PSAPSR3 /oracle/P80/sapdata11/sr3_3/sr3.data3
12 0 ###### 2.2 269 0 0 0.0
PSAPSR3 /oracle/P80/sapdata11/sr3_4/sr3.data4
9 0 ###### 3.6 18 0 0 0.0

Note: ##### means format exceeded

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms