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? :(