Tuesday, October 21, 2014

How to find table size on Oracle Database?

SELECT segment_name, tablespace_name,
ROUND((BYTEs/1073741824*100)/100) sizeGB,
ROUND((BYTEs/1048576*100)/100) sizeMB,
ROUND((BYTES/1024*100)/100) sizeKB
FROM USER_SEGMENTS
order by sizeKB desc;