Re: Autoextend

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 01 Oct 1999 09:45:38 +0800
Message-ID: <37F41242.33E9@yahoo.com>

Frank Calfo wrote:
>
> Is autoextend a good feature to turn on or is it better to leave it off and
> add datafiles manually as needed?
>
> Is there any performance advantage in using or not using autoextend?

As with most Oracle features - Autoextend can be very handy when used *sensibly*...

Examples of good use: Having autoextend on TEMP tablespaces and ROLLBACK tablespaces so that people "never" get sorting errors or rollback errors...since you can also shrink these tspace's back to a nominal size if required.

Examples of bad use: Turning it on everywhere since not enough planning was done to work out just how big things were going to get...

HTH Received on Thu Sep 30 1999 - 20:45:38 CDT