Re: Fed Up with being a DBA

Comments interspersed

Domenic G. wrote:

>I don't know about all of you, but I'm fed up with being a DBA and
>working in the IT industry. I've been an Oracle DBA for several years
>now and pride myself on knowing Oracle like the back of my hand.
>
>Here are my gripes ...
>
>- third party apps that run on Oracle and designed like junk.
>

I get paid by the hour.

>- third party apps that insist on "GRANT DBA TO ..."
>

I get paid by the hour.

>- schemas with FKs that aren't indexed (man do I hate that!)
>

I get paid by the hour.

>- poorly written queries (EXISTS and IN are like cryptonite!)
>

What on earth are you talking about? It is kryptonite with a "K"

>- the COST based optimizer which outsmarts itself more often than not
>

Nonsense. You just don't know Oracle nearly as well as you think.

>so that I have to to /*+ ORDERED INDEX(a b) USE_NL (w x y z) */ to
>achieve the same thing as /*+ RULE */
>

Reference above comment. But even if you were correct. I get paid by the hour.

>- schemas that still use CHAR(x)
>

Yeah. But I get paid by the hour.

>- DBAs who use DBCA to create a DB and it adds in all that unwanted
>JUNK!!
>

Not if you know how to use it. Once again obviously you don't know the back of your hand
as well as you think. And I am going to avoid make the obvious follow-on reference out of
professional courtesy.

>Cheers ...
>Domenic
>
>

Seriously ... your knowledge of Oracle isn't all that good. I'd suggest you find a senior level class
at a university and learn something newer than version 7. You are going to look pretty silly using
the RBO with a nested or partitioned table.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)