Check size of table in Oracle

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');

Category: DatabaseSQL

Tags:

2 comments

  1. Do you mind if I quote a few of your posts as long as I provide credit and
    sources back to your website? My blog site is in
    the exact same area of interest as yours and my visitors would certainly
    benefit from some of the information you provide here.

    Please let me know if this okay with you. Regards!

Leave a Reply

Article by: Shadab Mohammad