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

Thread: size of CONTEXT INDEX

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    size of CONTEXT INDEX

    Hi Friends,
    How do i find the size of context index.I checked in user_segments but was not able to find the segment name.

    Is there any other data dictionary object from which i find the size of context index

    regards
    anandkl
    anandkl

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    This will give you a little more information than you want but it will also give you the size of your index. I've found this script to be very versitial when it comes to seeing what objects are up to as far as size and extents go. You can also tighten the script down to be as specific as you want.

    select
    segment_name object_name ,
    segment_type object_type,
    tablespace_name ,
    round(sum(bytes)/1024/1024,2) Mb,
    sum(decode(extent_id, 0, bytes, 0)) initial_ex,
    sum(decode(extent_id, 1, bytes, 0)) next_ex ,
    max(extent_id)+1 extents ,
    sum(bytes) ttlsize
    from
    user_extents
    Where segment_type='INDEX'
    group by
    segment_name, segment_type, tablespace_name
    order by
    sum(bytes) DESC;


    Have fun!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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