Re: Autoextend

This is one of those oracle questions that can best be answered by "it depends". For some tablesspaces it can be a good idea but for others it might be a poor choice. It also depends on space availability on the disk. On a UNIX system with large availablity in the slice where the datafile exists then autoextend might work out, but if there is only limited space you might want to add another datafile on a different slice.

My general experience has been that once I turn autoextend on I have to pay attention to what happens with the datafiles. If I allow autoextend on the tablespace where my rollback segments reside I usually will shrink the datafiles back to a more reasonable size if they have been autoextended due to some large transaction.

My suggestion is that you give some thoughts to your goals, the system capacity, the usage of the tablespaces and then make a decision for each tablespace of how you want to treat handle it.

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?
Received on Fri Oct 01 1999 - 09:03:36 CDT