Re: Datafile setting

Frank wrote:

> Anup Jalan wrote:
> > Generally, autoextend datafile should be avoided. There is always the
> > danger of irresponsible transactions eating up too much space. Also,
> > frequent autoextend slows down the system.
> >
> > Better to estimate the max size you will need and allocate it upfront.
> >
> > However, when I feel too lazy to follow my own advice :), I set the
> > autoextend value to around 10% of the initial size, and the max value
> > to double the initial size.
> >
> <snip>
>
> Beware of the maximum file sizes on various platforms. ALWAYS (Oracle
> even listened to me...) use the MAXSIZE option in conjunction with
> autoextend.
>
> Frank

I can't think of a single reason to ever use autoextend. On what basis are you recommending otherwise?

Daniel Morgan Received on Mon Jan 20 2003 - 20:26:08 CST