Re: What is against autoextending datafiles? (was: autoextend = ???

From: Kerry Scott <kerrysco_at_ameritech.net>
Date: Mon, 9 Apr 2001 18:26:41 -0400
Message-ID: <BEqA6.1818$hI3.3444@nntp0.chicago.il.ameritech.net>

Howard, most would rather not find a 100% full filesystem as the error condition. Rather, they would like to limit growth to a known and reasonable volume. If a DBA is aware of the expected volume of data, as he should, and is monitoring growth, as he should, then there should be no issue. Kind of like load limits on a bridge. You wouldn't allow a fleet of trucks to park on it until it collapses.

Just my two cents.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3ad1706d$0$15029$ed9e5944_at_reading.news.pipex.net...
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3ace54f9_at_news.iprimus.com.au...
>
> > > Strike the pretty - it *is* a requirement, not only to keep from
filling
> > > up volumes,
> > > but also to avoid 2/4GB barries being crossed.
> >
> >
> > I think you'll find the operating system (ie, the file system) does a
fair
> > job of preventing that on it is own, with or without assistance from a
> > maxsize clause.
>
> ! Kinda depends on what you mean by 'a pretty good job'.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Mon Apr 09 2001 - 17:26:41 CDT