AWR reports question

From: CRISLER, JON A <JC1706_at_att.com>
Date: Fri, 9 Sep 2011 22:01:49 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD30D552D_at_MISOUT7MSGUSR9D.ITServices.sbc.com>

Given the following snippit from a 11gR1 db, the line "Block changes"- does that include redo as well ?

Cache Sizes                       Begin        End
~~~~~~~~~~~                  ---------- ----------
               Buffer Cache:   126,976M   126,976M  Std Block Size:         8K
           Shared Pool Size:    23,040M    23,040M      Log Buffer:   138,300K
 
Load Profile              Per Second    Per Transaction   Per Exec   Per Call
~~~~~~~~~~~~         ---------------    --------------- ---------- ----------
      DB Time(s):                9.1                0.4       0.01       0.00
       DB CPU(s):                0.7                0.0       0.00       0.00
       Redo size:          294,701.7           13,914.8
   Logical reads:           43,820.4            2,069.1
*  Block changes:            1,829.8               86.4
  Physical reads:               46.2                2.2
 Physical writes:              114.7                5.4
      User calls:            2,585.1              122.1
          Parses:              519.3               24.5
     Hard parses:               13.8                0.7
W/A MB processed:       25,411,313.0        1,199,836.5
          Logons:                1.1                0.1
        Executes:            1,627.6               76.9
       Rollbacks:                1.8                0.1
    Transactions:               21.2

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 09 2011 - 17:01:49 CDT