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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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...............

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2011

Added on May 27 2011

5 comments

8,809 views