From oracle-l-bounce@freelists.org Mon Apr 25 17:03:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3PM3C27023303 for ; Mon, 25 Apr 2005 17:03:12 -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 j3PM394Z023298 for ; Mon, 25 Apr 2005 17:03:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C36EF1863FC; Mon, 25 Apr 2005 16:00:42 -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 25907-07; Mon, 25 Apr 2005 16:00:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47BF7185B8A; Mon, 25 Apr 2005 16:00:42 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: RE: LOCALLY MANAGED EXTENT PERFORMANCE Date: Mon, 25 Apr 2005 16:58:54 -0400 Message-ID: <61C900F558E4184DBD8E177CC9D51F67035D76E1@msexdb06.lowes.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: LOCALLY MANAGED EXTENT PERFORMANCE Thread-Index: AcVJ1ylHc3yCkq9jQGiD2aWqPlBBmgAAinIA From: "Dogan, Ibrahim - Ibrahim" To: , X-OriginalArrivalTime: 25 Apr 2005 20:58:54.0353 (UTC) FILETIME=[97359810:01C549D9] X-archive-position: 18976 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ibrahim.Dogan@Lowes.com Precedence: normal Reply-To: Ibrahim.Dogan@Lowes.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.6 required=5.0 tests=AWL,LINES_OF_YELLING, SUBJ_ALL_CAPS autolearn=no version=2.63 No, it tells you the last extent size. That's pretty much your next extent in aoutoalloc LMT unless it is switching to next gear which will be just couple of times during the lifetime of a table.. I'm still waiting your "alert" code... Thanks, =20 Ibrahim DOGAN Sr. Sybase/Oracle DBA www.lowes.com > -----Original Message----- > From: oracle-l-bounce@freelists.org=20 > [mailto:oracle-l-bounce@freelists.org] On Behalf Of Tim Gorman > Sent: Monday, April 25, 2005 4:39 PM > To: oracle-l@freelists.org > Subject: Re: LOCALLY MANAGED EXTENT PERFORMANCE >=20 >=20 > Doesn't do the job. This only tells me what the largest=20 > extent sizes are for segments. It does not tell me whether=20 > any of them are possible to run out of space within "N" extensions... >=20 ... >=20 -- http://www.freelists.org/webpage/oracle-l