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

  • From: Ram Raman <veeeraman@xxxxxxxxx>
  • To: rjamya@xxxxxxxxx
  • Date: Wed, 27 Mar 2013 15:56:41 -0500

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


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2013