DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Jul 2002
    Posts
    205
    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Try bytes column of DBA_SEGMENTS view for the index segment you are interested in...
    Reddy,Sam

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    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
  •  


Click Here to Expand Forum to Full Width