Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get oracle table occupied size

mafaizMay 27 2011 — edited May 27 2011
Hi,
Actually my task is arrange to get an oracle table occupied size for a particular schema.
I have an query to get allocated table size,the query as follows

SELECT SEGMENT_NAME,sum (BYTES)/1024/1024 FROM user_SEGMENTS WHERE segment_type='TABLE' group by segment_name order by sum(bytes) desc;

But actually i need to get "how much space occupied for each table in that particular schema"

Thanks in advance...............
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2011
Added on May 27 2011
5 comments
8,829 views