Re: Datafile setting

Only if you have absolutely no idea how much space you will require.

Even then, better to monitor regularly and increase manually, unless you do not have regular DBA services available. Gives you more control over what's happening in you applications.

Anup Jalan
Rave Technologies
www.rave-tech.com

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E2CAFC0.60644AB1_at_exesolutions.com>...
> 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 Thu Jan 23 2003 - 04:32:03 CST