Re: Oracle 911 Article

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
http://www.centrexcc.com 


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: