My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
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 <DIR>/sr3.data1
6 0 ###### 1.0 32 0 0 0.0
PSAPSR3 <DIR>/sr3.data2
15 0 ###### 2.2 63 0 0 0.0
PSAPSR3 <DIR>/sr3.data3
12 0 ###### 2.2 269 0 0 0.0
PSAPSR3 <DIR>/sr3.data4
9 0 ###### 3.6 18 0 0 0.0

Note: ##### means format exceeded

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.