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 Get The Unused Space In Block Level?

User_OCZ1TAug 27 2012 — edited Aug 30 2012

Hi i am using 10.2.0.1.0 of oracle.

I want to calculate the unused space for particular object/Segment in my Production DB in terms of blocks/bytes. I dont have execute privileges 'DBMS_SPACE.UNUSED_SPACE' but i do have select rights on v$* views. So is there way to directly query any data dictionary to get the information regarding used/unused spaces for the segemnt, what is the datadictionary name?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2012

Added on Aug 27 2012

#general-database-discussions

11 comments

966 views