Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 911 Article

Re: Oracle 911 Article

From: Wolfgang Breitling <>
Date: Fri, 05 Mar 2004 07:30:12 -0700
Message-Id: <>

At 06:49 AM 3/5/2004, you wrote:

>Strangely what he calls "Unconventional Methods" I call "Conventional and
>Elementary Methods" in tuning trivial problems. Problem: missing indexes
>Solution: create missing indexes, Problem: missing statistics Solution add
>missing statistics, etc doesn't sound particularly "unconventional" to me
>(although if the site is migrating to CBO, I would prefer to just go back to
>the RBO as a safer emergency solution, if not migrating then what the hell
>happened to all the stats bar one table)
>His "Contrary to the pontifications of theoreticians and ivory-tower
>academics, there are many silver bullets for Oracle performance tuning"
>comments could possible by aimed at yours truly, for which I would be deeply
>flattered for the complement. However as I work full-time as a DBA dealing
>with real databases in real production environments solving real problems
>(how I wish it was always as simple as Don's examples), I might
>unfortunately be mistaken.

I was about to write a response akin to what you are saying here. I must be doing something wrong. I never get called to performance problems where the cause and solution are so elementary. I too would not call them silver bullets but a case of the DBA being asleep at the wheel, or more likely no DBA at the wheel at all. Maybe someone got sold a software that uses oracle as the storage back end and the powers who sign the cheque were told that a database is like an electronic filing cabinet, so the secretary or receptionist got the honorary title of DBA. No insult meant to secretaries and receptionists.

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Fri Mar 05 2004 - 08:45:40 CST

Original text of this message