Re: DBA Humor (Twisted, sick sort of stuff...)
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 27 Mar 2013 14:30:45 -0400
Message-ID: <CAGurbTOXSbsM6Br8342DX8ftquyURRq1D=nzVezzvroJmPV1XQ_at_mail.gmail.com>
In my previous job, I had that problem for a consultant designed datamart, it would routinely generate more redo than DB size daily and DR was constantly behind. Finally the business side listened to my analysis and changed all global indexe on (yes plural) on all fact tables, to local partitioned and dropped some indexes that were not useful. Boom, problem gone, DR was within 4-5 minutes of primary (we had limited bandwidth and locations were about 800 miles apart). as always each case is different,
Date: Wed, 27 Mar 2013 14:30:45 -0400
Message-ID: <CAGurbTOXSbsM6Br8342DX8ftquyURRq1D=nzVezzvroJmPV1XQ_at_mail.gmail.com>
In my previous job, I had that problem for a consultant designed datamart, it would routinely generate more redo than DB size daily and DR was constantly behind. Finally the business side listened to my analysis and changed all global indexe on (yes plural) on all fact tables, to local partitioned and dropped some indexes that were not useful. Boom, problem gone, DR was within 4-5 minutes of primary (we had limited bandwidth and locations were about 800 miles apart). as always each case is different,
Raj
On Wed, Mar 27, 2013 at 2:01 PM, <Christopher.Taylor2_at_parallon.net> wrote:
> yes processing lots of data several times a day as they re-test.
> Just humorous when your redo generated surpasses the actual application
> data.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 27 2013 - 19:30:45 CET