-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|