RE: Do programmers tune SQL?

Seen that before. And it wouldn't be so bad except the DBA's were complaining about the poor performing SQL. They blindfolded the developers, tied their hands behind their back, to the point they could not even generate an explain plan, much less do any tracing and use tkprof. And then complained about the developers turning out poor performing SQL.

I understand your plight.

> But I have been in places were security was very strict and:
>
> - I had, in database, only user account with limited rights - I
> didn't have
> access to PLAN_TABLE so after writing my SQL I had to ask DBA to
> run it. And the same if I changed it, and then I may have changed it
> number of times...
>
> - it was worse when I had to tune stored procedures. Again, I had only
> a user account but not the procedure owner account - so I wrote
> procedure, asked the DBA to compile it, run my statements, and
> maybe all over again...
>
> - I didn't have account on the UNIX server so when the trace file was
> generated I had to ask the DBA to run TKPROF and send me the
> output. In an extreme case I run into junior DBA who had never run
> TKPROF before so it took even more time explaining why I wanted to
> use explain=... and sys=no etc. Occasionally he had to contact senior
> DBA and wait for his response.
>
> On top of that DBAs had other tasks so sometimes it took quite some
> time to get a procedure recompiled, trace file generated, or run
> TKPROF. In one place there was a rule that DBAs had 48 hrs to
> respond to any request and sometimes it took that long.
>
> Sometimes a very simple task, that could be completed in few minutes,
> took days because of all procedural things. At the end it cost
> companies lot of money.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).