Re: AWR reports question

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Sat, 10 Sep 2011 12:25:07 +0800
Message-ID: <CAMNBsZv2yajUa_vYjsR_gnaEDCSqxEZB99kqVShOvvzywBOAmw_at_mail.gmail.com>

No, "block changes" does not include redo. The volume of redo is identified from 'redo size' and 'redo writes'. "block changes" is only about database block changes -- the number of block changes. Of course, an update to a database block also generates redo -- but the volume of redo is better identified by 'redo size' which is in bytes. Hemant K Chitale

On Sat, Sep 10, 2011 at 6:01 AM, CRISLER, JON A <JC1706_at_att.com> wrote:

> 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
>
>
>

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

Received on Fri Sep 09 2011 - 23:25:07 CDT