Calculate exact size for each partition
I used dba_segments and dba_extents. I found out segments shows by byte size. The number I came up with are way too small than the database backup size. For instance, I came up with about 70G and our database is about 400-450G. Where do my data go? Is there another better table can tell me my exact table size by partition? :(
How can find the exact size of the table?
I know the database is over 400G and mostly are the tables I am looking for but dba_extents only shows about 70G. What will be the other views or tables I can see the remaining size?