Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: LMT Autoallocate initial, tot # of extents
Just for info, I find with partitioned objects in LMT autoallocate, sometimes the last extent size of the partition will be smaller than the previous extent size.
select
segment_name,partition_name,extent_id,file_id,block_id,bytes/1024/1024
from
dba_extents
where tablespace_name = 'REMEDYIX'
and segment_name = 'SYMP_LOAD_ARCHIVE_YEAR_IX01'
order by 1,2,3
1 select
segment_name,partition_name,extent_id,file_id,block_id,bytes/1024/1024
sizeMb
2 from
3 dba_extents
4 where tablespace_name = 'REMEDYIX'
5 and segment_name = 'SYMP_LOAD_ARCHIVE_YEAR_IX01'
6* order by 1,2,3
SQL> /
SYMP_LOAD_ARCHIVE_YEAR_IX01 BAD_PART 0 155 2673 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 0 156 1465 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 1 112 1297 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 2 156 1473 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 3 112 1305 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 4 156 1481 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 5 112 1313 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 6 156 1489 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 7 112 1321 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 8 156 1497 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 9 112 1329 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 10 156 1505 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 11 112 1337 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 12 156 1513 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 13 112 1345 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 14 156 1521 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 15 112 1353 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 16 153 1161 1.0000 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 17 155 1417 1.0000 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2004 18 156 1545 5000 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 0 155 2681 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 1 153 2553 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 2 155 2689 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 3 153 2561 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 4 155 2697 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 5 155 2705 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 6 155 2713 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 7 155 2721 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 8 155 2729 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 9 155 2737 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 10 155 2745 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 11 155 2753 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 12 155 2761 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 13 155 2769 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 14 155 2777 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 15 155 2785 0625 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 16 156 2825 1.0000 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 17 112 2825 1.0000 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2005 18 153 2569 9375 SYMP_LOAD_ARCHIVE_YEAR_IX01 MONTH01_2006 0 112 32410625
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2005 - 14:33:36 CDT