size of CONTEXT INDEX
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
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.
segment_name object_name ,
sum(decode(extent_id, 0, bytes, 0)) initial_ex,
sum(decode(extent_id, 1, bytes, 0)) next_ex ,
max(extent_id)+1 extents ,
segment_name, segment_type, tablespace_name
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
Click Here to Expand Forum to Full Width