blocks and empty_blocks

[raztaboule]

Hi ,

1/ i supposed that blocks in dba_tables are the sum of the blocks of each extents of a table, and that empty_blocks is the same but for unused blocks .
Am'I right ?

2/ Why the same information is not present in dba_indexes ??

the purpose is to find and easy way to estimate the real size of one segment.


Thanks you !

 

[carp]

Why is it not available in dba_indexes? You'd have to ask Oracle, I suppose.

But all is not lost! If you want to know about a specific index, you can do the following:

VALIDATE INDEX my_index;

Once the index is validated, run the following query:

SELECT * FROM index_stats;

This will present you with information such as how many levels high your index tree is, how many leaf blocks, how many leaf rows, how many blocks, the most repeated key value, and lots of other useful information about your index.

Elbert, CO
1018 MDT

 

[raztaboule]

thanks a lot carp !
i will try that on monday !