I
SELECT segment_name, BYTES
FROM user_segments
WHERE segment_type = &1;
SELECT segment_name, SUM (BYTES) / 1024 / 1024
FROM user_extents
GROUP BY segment_name;
II Actual Size:
ANALYZE TABLE emp COMPUTE STATISTICS;
SELECT num_rows * avg_row_len
FROM user_tables--dba_tables
WHERE table_name = &2;