• From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Brandon.Allen@xxxxxxxxxxx
  • Date: Wed, 5 Oct 2005 09:28:31 +0100

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

Other related posts: