Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |