Re: DBA Humor (Twisted, sick sort of stuff...)

From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 27 Mar 2013 15:56:41 -0500
Message-ID: <CAHSa0M0O9X3rj9dpFb-k_EQHNJyZ8gNZZ9615D50d_PaAgOtDg_at_mail.gmail.com>



I am sure that speeded up the inserts on the tables with the concerned indexes.
Did that speed up some of the queries?

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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 27 2013 - 21:56:41 CET

Original text of this message