View the current user's size of each table, SUM (Bytes) / 1024/1024 from user_extents group by segment_name See the size of each table space occupancy: SELECT TABLESPACE_NAME, SUM (BYTES) / 1024/1024 from DBA_SEGMENTS Group by tablespace_name
