Re: Episode 2: the EntMgr Green Light!!

Couple of comments
"Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0311061812.6659e5dd_at_posting.google.com...
> Here is another episode of a typical day for me as a DBA ...
>
> Boss: I got a call from Mary that the database is down.
> Me: Hold on while I check ...
> Me: Just a sec while I open a cmd prompt ... sqlplus "/ as sysdba" ....
> Boss: Don't do that! -- go check the green light in OEM!
> Me: That's for babies.
> Boss: That is our documented procedure.
> Me: But it's faster for me this way.
> Boss: Please follow our documented procedure.
> Me: FUMING

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.

-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk