Check size of table in Oracle

Shadab Mohammad

12 years ago

SQL Query to check size of Table

— Check Size in GB

SELECT bytes/1024/1024/1024
FROM USER_SEGMENTS
WHERE SEGMENT_NAME in ('TABLE1','TABLE2');

— Check Size in MB

SELECT bytes/1024/1024
FROM USER_SEGMENTS
WHERE SEGMENT_NAME in ('TABLE1','TABLE2');

— Check Size in KB

SELECT bytes/1024
FROM USER_SEGMENTS
WHERE SEGMENT_NAME in ('TABLE1','TABLE2');