From oracle-l-bounce@freelists.org Wed Oct 5 03:31:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j958VjCA011069 for ; Wed, 5 Oct 2005 03:31:45 -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 j958VcvX011045 for ; Wed, 5 Oct 2005 03:31:38 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F8E81F2CE7; Wed, 5 Oct 2005 03:30:35 -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 09972-03; Wed, 5 Oct 2005 03:30:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 758801F2C87; Wed, 5 Oct 2005 03:30:34 -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=fL1nb1XtZbIfZ8g6VMSJqlkxK9jq9luw1dXWrLWGXE9LM95FSNAPqcsZ+7S6OBARdv/8VCN7Oq6yk7lqicxidQNHqJczg8bm6daJW+zKIeVqh87i/WM3gIK5AUK/ktXclmozMXXpKVRwLwKXmG61qawRgqInVGIgHRxi6boMG+U= Message-ID: <7765c8970510050128h15e047bdt45e6a988d1a81c18@mail.gmail.com> Date: Wed, 5 Oct 2005 09:28:31 +0100 From: Niall Litchfield To: Brandon.Allen@oneneck.com Subject: Re: AUTOEXTEND Cc: mark.powell@eds.com, oracle-l@freelists.org In-Reply-To: <04DDF147ED3A0D42B48A48A18D574C4503D3FAC5@NT15.oneneck.corp> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6417_25074107.1128500911730" References: <04DDF147ED3A0D42B48A48A18D574C4503D3FAC5@NT15.oneneck.corp> X-archive-position: 26329 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@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.2 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------=_Part_6417_25074107.1128500911730 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/4/05, Allen, Brandon wrote: > 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 waitin= g > 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. > This disadvantage is avoided if and only if the DBA actually does anticipate the growth and allocate space appropriately. If they don't the performance impact is failed transactions. In many, many environments anticipating space requirements is an inexact science to say the least and autoextend is a useful safety net for high availability. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ------=_Part_6417_25074107.1128500911730 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
On 10/4/05, = Allen, Brandon <Brandon= .Allen@oneneck.com> wrote:
Another disadv= antage 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 exten= d, then the end user has to incur the cost of waiting for the file to exten= d.  This is avoided if the DBA anticipates the growth and manually pre= -extends the datafile, or adds another data file to the tablespace.
 

 

This disadvantage is avoided if and only if the DBA actually does antici= pate the growth and allocate space appropriately. If they don't the perform= ance impact is failed transactions. In many, many environments anticipating= space requirements is an inexact science to say the least and autoextend i= s a useful safety net for high availability.=20




--
Niall Litchfield
Oracle DBA
= http://www.niall.lit= chfield.dial.pipex.com

------=_Part_6417_25074107.1128500911730-- -- http://www.freelists.org/webpage/oracle-l