Hi ,

could anybody help understanding some numbers in index_stats:
After ... validate structure on an index.
Here is the result:
I appended the segment_size and block_size from another source.

What could be the reason of that BTREE_SPACE is much smaller (approx
half) than segment_size?

Thanks,
Bertalan

HEIGHT 4
BLOCKS 9 482 880
LF_ROWS 1 318 913 944
LF_BLKS 9 434 135
LF_ROWS_LEN 25 059 364 936
LF_BLK_LEN 3 972
BR_ROWS 9 434 134
BR_BLKS 45 584
BR_ROWS_LEN 194 912 588
BR_BLK_LEN 8 012
DEL_LF_ROWS 478
DEL_LF_ROWS_LEN 9 082
DISTINCT_KEYS 2 545
MOST_REPEATED_KEY 4 812 366
BTREE_SPACE 37 837 603 228
USED_SPACE 25 254 277 524
PCT_USED 67
ROWS_PER_KEY 518 237
BLKS_GETS_PER_ACCESS 259 123
PRE_ROWS 0
PRE_ROWS_LEN 0
OPT_CMPR_COUNT 1
OPT_CMPR_PCTSAVE 0
BLOCK_SIZE 8 192
SEGMENT_SIZE 77 788 610 560






Oracle LazyDBA home page