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');
2 comments
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!
It’s alright. Please go ahead. I’m glad that you find this information useful.