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.
---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------