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 segments which has high allocated space but less utilized space?

Amit PatilMar 17 2015 — edited Mar 17 2015

Hi All,

In one of our DB when we checked the tablespace growth trend we found that allocated space was very large comparatively to used space.

I want to know the segments which  asks for more space but does not utilized.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2015
Added on Mar 17 2015
4 comments
416 views