SCRIPT TO FIND HOW MUCH SPACE OCCUPIED BY AN INDEX..?

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...

Quote:

---

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