-
HI,
I have one index in one table. I have allocated initial extent 40MB and next 40MB for the index. It has taken one extent only.
Any one has any script to know , how much really it has occupied, out of 40 MB of space for index..?
SKD
-
Try bytes column of DBA_SEGMENTS view for the index segment you are interested in...
Reddy,Sam
-
Try bytes column of DBA_SEGMENTS view for the index segment you are interested in...
__________________
Reddy, Sam
BYTES in DBA_SEGMENT will show the allocated bytes not the actually used.
use DBMS_SPACE to see the actual space.
HTH
Sanjay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|