Been working on queries to determine the actual amount of data stored in my database, excluding sys and system schemas. I have looked at dba_tables, retreived the blocks, empty_blocks information for my tables. I have taken these numbers, multiplied by my block size, and compared to the highwater mark. The numbers just are not jiving. I thought that I could add the blocks and empty blocks value for each object, multiply by the block size, and get a number close to what I have allocated for the tablespace.

Question 1: What numbers to do I need to be looking at to determine the amount of data in a given schema?

Question 2: How do I compute the same figures for the indexes? I have them stored in seperate tablespaces/datafiles.

Any help in clearing my confusion is greatly appreciated.

Thanks