Skip to Main Content

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!

how to find the top 10 tables and indexes

user13364377Feb 28 2014 — edited Mar 4 2014

Hi All,

How can i find the top 10 space consuming tables and indexes in the database and how much fragmented space can be reclaimed.

DB version:11.2.0.2

OS:AIX 6.1

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2014
Added on Feb 28 2014
13 comments
12,396 views