Oracle Database Discussions

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!

Wasted/Free space in Segment (Table/Index)

The_RockApr 22 2008 — edited Feb 23 2010

What is the query that shows the segment space, occupied space, and free space? I want to know the status of my tables in production database. Whether they contain wasted/free space or not.

Suppose, there were 100 rows in a table. 50 rows are deleted.
HOw would I do know the table had 100 rows and now it has 50 rows? and it has some free/wasted space.

Besides that Is there any graphical tool/Option in EM that show the High Water Mark of Specific object?

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2010

Added on Apr 22 2008

#general-database-discussions

11 comments

11,966 views