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

Hi Frank,
It's generally suggested to avoid it if you can because of the overhead involved in Oracle checking and managing file sizes..same argument applies with any other object that can change size dynamically .

I saw a good post by Niall Litchfield in comp.databases.oracle.misc (I think) today which I tend to agree with ..if you've got a max size parameter it's probably not the end of the world if you autoextend.

S

Frank van Bortel wrote:

>
> Please elaborate as to why (proof, please!) autoextending datafiles
> is a bad idea?
> (In a highly tuned env, I agree - for civil servants, I tend to use it)
>
> --
> Gtrz,
>
> Frank van Bortel
  Received on Thu Apr 05 2001 - 13:34:39 CDT