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 Autoallocate initial, tot # of extents

Re: LMT Autoallocate initial, tot # of extents

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 6 Jun 2005 14:23:49 -0400
Message-ID: <BAY103-DAV46984B59D67B1C5D4BD3AA6FB0@phx.gbl>

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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 06 2005 - 14:33:36 CDT

Original text of this message

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