Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: AUTOEXTEND

Re: AUTOEXTEND

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 5 Oct 2005 09:28:31 +0100
Message-ID: <7765c8970510050128h15e047bdt45e6a988d1a81c18@mail.gmail.com>


On 10/4/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> 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 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.
>

  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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 05 2005 - 03:31:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US