Oracle Applications
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;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment