Thanks Samir, I found this a bit confusing ... why because for one of the indexes, this is from dba_extents ...
select segment_name, bytes, count(extent_id) from dba_extents where segment_name = 'STAT_TOTALS_PK' group by segment_name, bytes order by bytes Segment Name Bytes No Of Extents ------------------------------------------- STAT_TOTALS_PK 1048576 49 STAT_TOTALS_PK 5242880 1 STAT_TOTALS_PK 6291456 1 STAT_TOTALS_PK 8388608 121 So, I have 49 extents of 1M, 1 extent of 5M and 6M each and 121 extents of 8M. When I rebuild the index (using alter index), I asked for initial extent of 512M, but that was ignored .... Why would there be an extent of 5M & 6M? The db is 9i and tablespace is lmt autoallocate. Thanks in advance for ideas ... Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art !
*********************************************************************1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *********************************************************************1
