Re: AWR reports question
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: JC1706@xxxxxxx
- Date: Sat, 10 Sep 2011 12:25:07 +0800
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@xxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
