Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: LMT Autoallocation question

RE: LMT Autoallocation question

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 16 Nov 2001 05:43:54 -0800
Message-ID: <F001.003C73E7.20011116051517@fatcity.com>


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
Received on Fri Nov 16 2001 - 07:43:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US