All,

I have been writing some table/index analysis scripts recently, and am now looking to make them backward compatible with Server version 7.

I am just curious about data available within the DBA_TABLES view.

In my current report, I look at how much free space is available on a table segment's freelist by calculating:

DBA_TABLES.AVG_SPACE_FREELIST_BLOCKS x
DBA_TABLES.NUM_FREELIST_BLOCKS

Unfortunately, in the V7 dictionary this information is not available.

Does anyone know if it is calculable from data stored elsewhere in the dictionary, or via a PL/SQL util package?

Furthermore, if we try looking at the number of blocks visible in DBA_SEGMENTS and DBA_TABLES, I get the followig results:

'blocks' assigned under DBA_SEGMENTS differs from 'blocks' in DBA_TABLES for the same segment. Neither does it appear to add up to 'blocks' + 'empty_blocks'.

Anyone any enlightenment to shed on any of the above?

:-)

- Tony