From oracle-l-bounce@freelists.org Tue Oct 4 16:32:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j94LW0t7012885 for ; Tue, 4 Oct 2005 16:32:00 -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 j94LVvvX012873 for ; Tue, 4 Oct 2005 16:31:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 12CEC1F1930; Tue, 4 Oct 2005 16:31:13 -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 20637-03; Tue, 4 Oct 2005 16:31:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 867C91F1B72; Tue, 4 Oct 2005 16:31:12 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=s0oAlLAx7+99wyK7za53ZV/mmGxrzeQcKGPhzIaIK5ayXuc0hmMT8ttfFkIHaxmkII+hXLnHT09X6KjQfIIa2y9d8qgaKBgNcvTN1k+HJDoZjrORlbdVB3xc4R5+jyjLEBuNym/RYLB+xvcHL+nG+bg2PWUDG2UKhLd2zH0SzI8= Message-ID: Date: Tue, 4 Oct 2005 14:29:16 -0700 From: Jared Still To: Michael McMullen Subject: Re: AUTOEXTEND Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8019_13312899.1128461356077" References: <20051004190858.99828.qmail@web34514.mail.mud.yahoo.com> X-archive-position: 26317 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_8019_13312899.1128461356077 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/4/05, Michael McMullen wrote: > > How does autoextend relate to full table scan (FTS)? Or, is it bad to FTS > the tables that caused multiple autoextends? > > If you know a table will be large, and will be subject to FTS, allocating the space all at once will make it contigous. The impact of not doing so is probably not all that bad. It is much like the multiple extents argument. ie. you usually don't need to worry about it. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_8019_13312899.1128461356077 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/4/05, Michael McMullen <ganstadba@hotmail.com> wrote:
=
How does autoextend relate to full table scan (FTS)? Or, is it bad to FTSthe tables that caused multiple autoextends?

If you know a table will be large, and will be subject to FTS, allocating t= he
space all at once will make it contigous.

The impact of not doing so is probably not all that bad.  It is much like the multiple extents argument.  ie. you usually don't need to
worry about it.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist<= br> ------=_Part_8019_13312899.1128461356077-- -- http://www.freelists.org/webpage/oracle-l