From oracle-l-bounce@freelists.org Mon Jun 6 14:33:36 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j56JXaM8008068 for ; Mon, 6 Jun 2005 14:33:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j56JXVNi008059 for ; Mon, 6 Jun 2005 14:33:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D328E1BBF91; Mon, 6 Jun 2005 13:26:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02785-07; Mon, 6 Jun 2005 13:26:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4E0841BBD9B; Mon, 6 Jun 2005 13:26:24 -0500 (EST) Message-ID: X-Originating-IP: [65.54.174.207] X-Originating-Email: [ganstadba@hotmail.com] X-Sender: ganstadba@hotmail.com From: "Michael McMullen" To: References: <47a6f72b050606091954e0f98c@mail.gmail.com> <47a6f72b05060610165c719577@mail.gmail.com> <47a6f72b0506061041123c418f@mail.gmail.com> Subject: Re: LMT Autoallocate initial, tot # of extents Date: Mon, 6 Jun 2005 14:23:49 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-OriginalArrivalTime: 06 Jun 2005 18:24:24.0417 (UTC) FILETIME=[F73F1D10:01C56AC4] X-archive-position: 20708 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ganstadba@hotmail.com Precedence: normal Reply-To: ganstadba@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=AWL,UPPERCASE_25_50 autolearn=no version=2.63 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