Re: New oracle myths?

It's easy to demonstrate that Don has made some important technical errors, including
these:

1. Don says that the trace files are in hex. If you've ever looked at one, you'll realize of course that they're not.
2. On index rebuilds. Don uses a link when mentioning metalink note 77474.1 (although I think he means note 77574.1) that actually points to an article by a Boris Milrud called "Detecting and Fixing Out-of-Balance Indexes". Can I strongly suggest you read this as it's one of the few articles I know that is full of nearly every Oracle index myth there is
   (indexes become unbalanced, some leaf nodes have more levels than others,
   deleted space is not reused, etc.etc.). This is an article that Don uses to support his argument for index rebuilds. Can I then suggest you read my presentation on Oracle Index myths where I attempt to explain and prove why such myths are incorrect
   (http://www.actoug.org.au/Downloads/oracle_index_internals.pdf).
   

Before you believe anything that Don or I or anyone else writes, you deserve to see evidence that supports or refutes the hypotheses presented to you. This is mine.

Cheers

Richard

• Original Message ----- From: "Darrell Landrum" <darrell_at_landrum.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, September 01, 2004 6:53 AM Subject: New oracle myths?

Take a look at:

http://www.dbazine.com/burleson25.shtml

This is a must see, because I believe (me, my own belief, not any company, list, or other entity) there are folks on this list, umm, mentioned is a word that comes to mind.
;)

---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004