Re: Maximum height of an Oracle B-tree index

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 27 Mar 2004 15:00:29 -0000
Message-ID: <00c401c4140c$4e7ca090$7102a8c0@Primary>

Lex,

I've just written a new script to prove
the point. It takes a couple of seconds to run on 9.2 and bombs out with

ORA-00600 [6051]
when you hit the blevel = 24 / height = 25

So whatever the reason, the documentation is correct.

(The script doesn't fail on 10.1, because the leaf-block split algorithm seems to have changed)

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar

Original Message ----- From: "Lex de Haan" <lex.de.haan_at_naturaljoin.nl> To: <oracle-l_at_freelists.org> Sent: Saturday, March 27, 2004 1:59 PM Subject: RE: Maximum height of an Oracle B-tree index

: I should have looked in my own documentation, of course -- thanks for the
: correction Jonathan...
: kdxcolev is indeed part of each branch or leaf index block, and it is UB1.
I
: also found the same note, saying that the max value is 23, so we have max
24
: levels (0 thru 23) but unfortunately, I don't have an explanation why :-(
:

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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
-----------------------------------------------------------------

Received on Sat Mar 27 2004 - 08:57:30 CST