RE: Q: redo bytes statistics is it sum of all members or not ?
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Jun 2014 10:39:22 +0000
You're correct.
You could think of it as a "logical" measure of redo generated and written.
When you look at the stat physical write total bytes", that's when you have to
multiple by the number of copies before adding to the total, and don't forget
that "redo blocks written" is derived from "redo size" + "redo wastage".
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of amihay gonen [agonenil@xxxxxxxxx]
Sent: 25 June 2014 11:09
To: ORACLE-L
Subject: Re: Q: redo bytes statistics is it sum of all members or not ?
some question for "redo size" statistic as well
thanks .
On Wed, Jun 25, 2014 at 12:51 PM, amihay gonen
<agonenil@xxxxxxxxx<mailto:agonenil@xxxxxxxxx>> wrote:
Hi DBA's - quick question
According to my tests the statistic "redo blocks written" is not a sum of redo
block written to all redo memebers.
I've run test with instance with 2 members and then with 3 members and this
metric didn't change.
but just to make sure I didn't missed something :)
I wander if anyone has test it and can approved this conclusion .
thanks ,
amihay
Other related posts:
