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@xxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> 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@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 -----------------------------------------------------------------