Re: O9i: How to create a matching index to a given query

On 02.04.2007 12:32, sybrandb wrote:
> So that is why I am saying: Know they data. This is also why
> *developers* should tune applications instead of DBAs. My experience
> tells me most developers know exactly zilch about statement tuning,
> which forces me to reverse engineer the datamodel and application. As
> you are probably aware, those developers invariably blame the database
> for being slow, where it is usually their fault.
> Tuning is not trial and error. Tuning is a craft and sometimes an art.
> But I only became good at it, because developers still are refusing to
> do their job, and just throw their applications over the fence.

Even if developers would do a great job I presume there would be plenty of tuning options left for you (disk allocation, backup strategy etc.). :-)

I believe what you say is exactly why Tom Kyte starts his book with the chapter "It's a team effort". Developers typically may know their data and access patterns but it's usually the DBA's who know Oracle inside out.

I personally am a software engineer and I'd say I know a bit about Oracle internals - because I'm interested in the matter. But I guess the average developer either lacks interest or resources; developers are typically not sent to an Oracle DBA training... (Although that certainly would be helpful in many cases.)

Kind regards

        robert Received on Mon Apr 02 2007 - 06:44:38 CDT