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;

1 comment:

  1. Thanks and Regards. Oracle Apps R12 & Fusion Training Videos at affordable cost. please check oracleappstechnical.com for details.

    ReplyDelete