Re: Datafile setting

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 Received on Wed Jan 22 2003 - 15:33:08 CST