Treedump Interpretation

From: mkb <mkb125_at_yahoo.com>
Date: Mon, 24 Oct 2005 12:53:03 -0700 (PDT)
Message-ID: <20051024195303.32149.qmail@web32805.mail.mud.yahoo.com>

Hola Folks,

I'm just begining my first forays into treedumps. I came across Richard Foote's excellent presentation (http://www.actoug.org.au/Downloads/oracle_index_internals.pdf) . Heavy read for me at least.

Anyway, question is how does one interpret then nrows and rrows values?
branch: 0x784d417 126145559 (0: nrow: 4, level: 2)  branch: 0x7c57042 130379842 (-1: nrow: 705, level: 1)

    leaf: 0x784d433 126145587 (-1: nrow: 297 rrow: 297)

    leaf: 0x784d72b 126146347 (0: nrow: 300 rrow: 300)     leaf: 0x784d741 126146369 (1: nrow: 300 rrow: 300)

For the leaf values, what does nrow and rrow mean; num of possible index entries vs. number of actual entries?

Can't find any mention of it elsewhere, although I have to admit, I have not been able to fully digest the entire article.

--

mohammed                 

---

Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 24 2005 - 14:55:08 CDT