Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Episode 2: the EntMgr Green Light!!

Re: Episode 2: the EntMgr Green Light!!

From: Domenic G. <domenicg_at_hotmail.com>
Date: 7 Nov 2003 15:36:56 -0800
Message-ID: <c7e08a19.0311071536.59d4125a@posting.google.com>


> I'm all in favour of documented procedures myself. If the procedure is poor
> then surely the appropriate response is to produce a revised procedure, test
> it and update the procedures documentation. After all if I went into a bank
> and said Can I have $2000 cash from my account please, and they accepted a
> letter from my mother as proof of identity, I'd be a bit peeved. And yes a
> letter from my mother would be reliable evidence.
>
> >
> > Two hours later ...
> >
> > Boss: What are you working on?
> > Me: Looking through index_stats to see if any indexes need rebuilding.
> > Boss: Check with the vendor first to see if they allow that.
> > Me: Don't worry, it's just normal routine DBA stuff.
> > Boss: Still, please check.
> > Me: Don't worry, it won't affect functionality -- they won't care either
> way.
> > Boss: Still, please check.
>
> If I were a vendor I might well care. Why might I care?
>
> 1. You are proposing to do a lot of work on the database, for probably no
> benefit and at some cost.
> 2. What happens if you do 'ALTER INDEX <BLAH> REBUILD <NEW TABLESPACE>'.
> 3. What about alter index <blah> rebuild compress 1;
>
> In addition 'routine dba stuff' can easily be excluded by vendors.
> Collecting and keeping stats up to date, routine dba task but not a good
> idea in a siebel shop.
>
> > Time to look for a new job -- this is a romper room Oracle shop
> > Dom.
>
> I think I have a history of not especially linking GUIs or strange demands
> from vendors but you seem to be describing a shop that
>
> 1. documents its procedures and insists employees follow them
> 2. ensures that it doesn't break support contracts.
>
> Seems mature and sensible to me.

Why would vendors care if I rebuild one of their indexes. Is there a law banning it somewhere? Documented procedures are for drones or monkeys -- level 1 support, not for trained professionals.

Screw support contracts -- they're just an excuse to do nothing. Received on Fri Nov 07 2003 - 17:36:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US