Tuesday, March 26, 2013

changes ( fixes really ) in the 11.2 AWR report make me grumpy

Sorry for anyone that may have seen this already via Oracle L ... some volleying back and forth on this item ( and thanks to Jonathan Lewis ).

This is the same approximate workload ( one week in between ) on an 11.1 system and now running on 11.2.

Just some of the top things from the AWR report here.

Looks like Oracle counts parses different in 11.2 ( does not count as a parse a hit in the session_cached_cursors area ) and also fixed reporting the W/A MB processed number.  In 11.1 it should have been divided by ( 1024 * 1024 ) to give megabytes correctly.

11.1.0.7.12 ...
Load Profile              Per Second    Per Transaction   Per Exec   Per Call
~~~~~~~~~~~~         ---------------    --------------- ---------- ----------
      DB Time(s):                1.4                0.0       0.00       0.00
       DB CPU(s):                0.7                0.0       0.00       0.00
       Redo size:          109,808.0            2,749.8
   Logical reads:           13,060.0              327.0
   Block changes:              725.7               18.2
  Physical reads:              593.6               14.9
 Physical writes:               44.2                1.1
      User calls:            4,492.2              112.5
          Parses:            1,813.0               45.4
     Hard parses:                2.0                0.1
W/A MB processed:        1,089,100.0           27,272.6
          Logons:                1.7                0.0
        Executes:            1,871.9               46.9
       Rollbacks:                0.2                0.0
    Transactions:               39.9
   
11.2.0.3.5 ...
Load Profile              Per Second    Per Transaction   Per Exec   Per Call
~~~~~~~~~~~~         ---------------    --------------- ---------- ----------
      DB Time(s):                0.7                0.0       0.00       0.00
       DB CPU(s):                0.6                0.0       0.00       0.00
       Redo size:           98,996.9            2,831.7
   Logical reads:           11,926.5              341.2
   Block changes:              618.0               17.7
  Physical reads:              310.8                8.9
 Physical writes:               46.6                1.3
      User calls:            4,770.8              136.5
          Parses:               98.2                2.8
     Hard parses:                2.0                0.1
W/A MB processed:                1.0                0.0
          Logons:                1.7                0.1
        Executes:            1,998.8               57.2
       Rollbacks:                0.1                0.0
    Transactions:               35.0

No comments:

Post a Comment