Oracle Table Etiketli Yazılar

Oracle – Tablo Veri Boyutları (MB)

SELECT
owner AS "OWNER",
segment_name AS "OBJECT",
partition_name AS "PARTITION",
tablespace_name AS "TABLESPACE",
segment_type AS "TYPE",
ROUND (bytes / 1024 / 1024, 2)  AS "Boyut(MB)"
FROM dba_segments
WHERE segment_type IN ('TABLE', 'TABLE PARTITION')
AND owner = 'ABALI2011'
Order by ROUND (bytes / 1024 / 1024, 2) desc