Re: Adding new datafile question

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote

> >> I think auto extending datafiles are an evil. It removes control from
> >> *you* and gives it to a piece of software to do. I can never be
> >> comfortable not controlling how much space has been allocated to the
> >> database. Worse, auto extends make a damn poor crutch for space
> >> planning.
> >>
> >> --
> >> Billy
> >How so? I would think it perfectly reasonably when planning to add a
> >datafile to make it start small and autoextend up to a defined limit.
> >
> >
> Especially if otherwise someone would be called from his bed to fix
> it.

And what if the o/s file system's limit is reached by an autoextending tablespace? Same problem. Same phone call.

Only, with no auto extending *and* monitoring free space you would have known upfront that the tablespace will be running short of space. Less variables to deal with than when using auto extending. Especially with more than one tablespace auto extending on the same file system.

--
Billy