Re: LMT Autoallocate initial, tot # of extents

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 6 Jun 2005 14:23:49 -0400


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     3241
0625
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2005