Oracle Tablo Boyutları Görme

SELECT owner, segment_name AS table_name, bytes/1024/1024 AS size_in_mb

FROM dba_segments

WHERE segment_type = 'TABLE'

ORDER BY size_in_mb DESC

SELECT tablespace_name, SUM(bytes) / (1024 * 1024) AS total_size_mb

FROM dba_data_files

GROUP BY tablespace_name

ORDER BY tablespace_name;