AWR Report Shows Huge Numbers For Av/Rd (Doc ID 465106.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
IBM z/OS on System z

Symptoms

AWR report on z/OS shows huge numbers for Av/Rd:

1. create table test as select * from dba_segments; 
2. insert into test select * from test; 
3. repeat step 2 until we get around 400.000 rows inserted in the table. 
4. commit; 
5. take a snapshot and generate a new awr report. 
6. run the 

SELECT name, phyrds, phywrts, readtim, maxiortm 
FROM v$datafile df, v$filestat fs 
WHERE df.file# = fs.file#; 

NAME                            PHYRDS PHYWRTS READTIM MAXIORTM 
----------------------------------------------------------------
//'EMEASUP.ECS4.SYSTEM.DB1'     5350    398    132631   39645 
//'EMEASUP.ECS4.SYSTEM.DB2'     6067    627    355993    8189 
//'EMEASUP.ECS4.SYSTEM.UNDO.DB1' 570    941    122780   40894 
//'EMEASUP.ECS4.SYSTEM.UNDO.DB2' 378   1181    525739  102263 
//'EMEASUP.ECS4.SYSAUX.DB1'     3715   1771    164994   42149 
//'EMEASUP.ECS4.USERS.DB1'      1430   5034     21277    1585 
//'EMEASUP.ECS4.USERS.DB2'      1542   4904     42885    7566 
//'RAZTEST.DB1'                20544  37108    256236    7557 
//'SWINGB.CCINDEX.DBF'            17     29     79577   13511 

RAZTEST.DB1 is the tablespace where the table has been created and were I/O were generated

The AWR report looks like this:

                                                      Av       Av
Tablespace   Filename                       Reads     Reads/s  Rd(ms)
--------------------------------------------------------------------
CCINDEX    //'SWINGB.CCINDEX.DBF'           13         0   ######
RAZTEST    //'RAZTEST.DB1'                  20,542     8   121.2<==not real  
SYSAUX     //'EMEASUP.ECS4.SYSAUX.DB1'      247        0   ######
SYSTEM     //'EMEASUP.ECS4.SYSTEM.DB1'      1,141      0   541.0
SYSTEM     //'EMEASUP.ECS4.SYSTEM.DB2'      1,208      0   584.9
UNDOTBS    //'EMEASUP.ECS4.SYSTEM.UNDO.DB1' 537        0   ######
UNDOTBS    //'EMEASUP.ECS4.SYSTEM.UNDO.DB2' 325        0   ######
USERS      //'EMEASUP.ECS4.USERS.DB1'       764        0   134.9
USERS      //'EMEASUP.ECS4.USERS.DB2'       775        0   325.2

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