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

Advertisements

2 thoughts on “Check size of table in Oracle

  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!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s