Re: New oracle myths?
- From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 08:44:43 +1000
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@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
