IN ORACLE MILIEU …

I ran into a scenario where I really wanted to check whats inside the leaf block of an index. This post is to dig inside the index leaf block and find out various facts stored inside a block. We will start with taking a dump of a block SYS.ORCL>alter session set tracefile_identifier=’INDEX_BLOCK_DUMP’; Session altered. SYS.ORCL>alter [...]