Query to find the space used by a table in Oracle

Query to find the space used by a table in Oracle

🕑 Published : Apr 15, 2018 | 🕣 Updated : Apr 15, 2018 | ⏳ 1 Min read

📁Oracle #️⃣Oracle

Query to find the space used by a table

SELECT DS.TABLESPACE_NAME
	,        SEGMENT_NAME
	,        ROUND(SUM(DS.BYTES) / (1024 \ * 1024)) AS MB
	,        ROUND(SUM(DS.BYTES) / (1024 \ * 1024 \ * 1024)) AS GB    FROM DBA_SEGMENTS DS  
WHERE SEGMENT_NAME IN        (SELECT TABLE_NAME            FROM DBA_TABLES           WHERE TABLE_NAME = 'REQUIRED_TABLE_NAME')  
GROUP BY DS.TABLESPACE_NAME
	,SEGMENT_NAME;