Re: DBA Humor (Twisted, sick sort of stuff...)
- From: rjamya <rjamya@xxxxxxxxx>
- To: Ram Raman <veeeraman@xxxxxxxxx>
- Date: Thu, 28 Mar 2013 08:35:54 -0400
What queries? LOL !! I said "consultants designed datamart". Which means
they had the datamart, but,
1. no one had defined how it will be used
2. No one knew how to query it
3. No one could query it once it was loaded since they did so much of
transformation in their (ahem) ETL process.
So, it was a datamart that loaded about 40m_ rows every night into a DB,
which were promptly useless. Data retention was supposed to be 7 years, we
fought hard to bring it down to 3. Mind this, it was a standalond db, with
a DR, (they also wanted a HA as well as a GG replicated copy for
"reporting" purpose). After listening to costs, only primary and HA
remained.
I dont know the current status, everything else was running smoothly,
except for this one.
Raj
On Wed, Mar 27, 2013 at 4:56 PM, Ram Raman <veeeraman@xxxxxxxxx> wrote:
> I am sure that speeded up the inserts on the tables with the concerned
> indexes.
>
> Did that speed up some of the queries?
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » DBA Humor (Twisted, sick sort of stuff...)- Christopher.Taylor2
- » Re: DBA Humor (Twisted, sick sort of stuff...)- Orlando L
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Christopher.Taylor2
- » Re: DBA Humor (Twisted, sick sort of stuff...)- Andrew Kerber
- » Re: DBA Humor (Twisted, sick sort of stuff...)- Hans Forbrich
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Grabowy, Chris
- » Re: DBA Humor (Twisted, sick sort of stuff...)- rjamya
- » Re: DBA Humor (Twisted, sick sort of stuff...)- Ram Raman
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Keith Moore
- » Re: DBA Humor (Twisted, sick sort of stuff...) - rjamya
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Sheehan, Jeremy
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Stephens, Chris
- » Re: DBA Humor (Twisted, sick sort of stuff...)- coskan gundogar
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Schauss, Peter (ESS)
- » RE: DBA Humor (Twisted, sick sort of stuff...)- Fergal Taheny