Re: redo per second (size)on exadata ?
Date: Thu, 28 Aug 2014 09:34:11 -0700
Message-ID: <CAA2Dszxk4Q0a2SVPEMK5rDfUKpOEbiys6xtx5z2f8RxfyUtxnA_at_mail.gmail.com>
Hi
80Mb/sec or 80MB/sec? In network layer bits-per-second is used, almost, everywhere else, Bytes-per-second is quoted.
However, a 6 node cluster that we managed a few years ago generates about 200GB/hour at the peak(about 11AM). But, the peak rate tapers off abruptly about 60GB/hour , in both ends of a graph, during business hours. Generates less than 20GB per hour later in the day.
Backup of archive log files alone exceed incremental backup size some days and the Dataguard catches up only the next day morning.
Does the application need to generate that much redo? Well, let's just say that there is a huge opportunity to reduce redo :)
Cheers
Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com - Specialists in Performance,
RAC and EBS
Blog: http://orainternals.wordpress.com/
Oracle ACE Director and OakTable member <http://www.oaktable.com/>
Co-author of the books: Expert Oracle Practices <http://tinyurl.com/book-expert-oracle-practices/>, Pro Oracle SQL, <http://tinyurl.com/ahpvms8> <http://tinyurl.com/ahpvms8>Expert RAC Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices <http://tinyurl.com/book-expert-plsql-practices>
<http://tinyurl.com/book-expert-plsql-practices>
On Thu, Aug 28, 2014 at 3:54 AM, amihay gonen <agonenil_at_gmail.com> wrote:
> Hi all,
> I've been asked by our VP to give estimation what is consider heavy system
> OLTP in term of redo per bytes rate.
>
> She told to to test our exadata machine with load of 80Mb per second per
> Node , and I've told her that I think it is too much .
>
> if OLTP system with generate 80Mb* (2 nodes) per second that it means 576G
> per hour .
>
>
> I wonder if anyone work with such systems , what is the typical redo rate ?
>
>
> thanks
> amihay
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 28 2014 - 18:34:11 CEST