Why do you diss the Oracle documentation, and then fail to show the OP a method that does work?I mention Metalink Note 122008 a number of times in my Index Seminar as a perfect example of how not to determine when to rebuild an index.
Interestingly, Oracle DBA Jim Spath has shown that regular rebuilding of high DML indexes should be scheduled on a regular basis:Thankfully, Oracle have pulled the error filled note from Metalink
burleson wrote:Don,It depends on how you define "unbalanced"!By design they can not become unbalanced. EVER!
When Oracle does a logical delete of a leaf node, the "logical" structire of the b-tree is out of balance.