From oracle-l-bounce@freelists.org Tue Oct 4 15:55:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j94KtCsv007181 for ; Tue, 4 Oct 2005 15:55: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 j94Kt4vX007161 for ; Tue, 4 Oct 2005 15:55:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 01CF11F2702; Tue, 4 Oct 2005 15:52:54 -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 14614-01; Tue, 4 Oct 2005 15:52:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D81A1F2426; Tue, 4 Oct 2005 15:52:53 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C925.8DF673E5" Subject: RE: AUTOEXTEND Date: Tue, 4 Oct 2005 13:52:38 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C4503D3FAC5@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: AUTOEXTEND thread-index: AcXJF6PllM6xX06PSaGvfukEZ7OaOAABJbiQAAIuSCA= From: "Allen, Brandon" To: , X-archive-position: 26312 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.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=-4.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5C925.8DF673E5 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Another disadvantage that hasn't been mentioned yet is the performance = impact - if a user is inserting rows and fills up the tablespace to the = point it has to extend, then the end user has to incur the cost of = waiting for the file to extend. This is avoided if the DBA anticipates = the growth and manually pre-extends the datafile, or adds another data = file to the tablespace. =20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of Powell, Mark D Sent: Tuesday, October 04, 2005 1:08 PM To: oracle-l@freelists.org Subject: RE: AUTOEXTEND I think auto-extend datafiles are a very bad idea. =20 Privileged/Confidential Information may be contained in this message or = attachments hereto. Please advise immediately if you or your employer do = not consent to Internet email for messages of this kind. Opinions, = conclusions and other information in this message that do not relate to = the official business of this company shall be understood as neither = given nor endorsed by it. ------_=_NextPart_001_01C5C925.8DF673E5 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Another disadvantage that hasn't been = mentioned yet is=20 the performance impact - if a user is inserting rows and fills up the = tablespace=20 to the point it has to extend, then the end user has to incur the cost = of=20 waiting for the file to extend.  This is avoided if the DBA = anticipates the=20 growth and manually pre-extends the datafile, or adds another data file = to the=20 tablespace.
 
-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of Powell, Mark D
Sent: Tuesday, October 04, 2005 = 1:08=20 PM
To: oracle-l@freelists.org
Subject: RE:=20 AUTOEXTEND

I think auto-extend datafiles are a very = bad=20 idea.  =