Re: Autoextend switch

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0306130214.fa3e339_at_posting.google.com>...
> rooty_hill2002_at_yahoo.com.au (Gary) wrote in message news:<171bd226.0306122211.50ec871_at_posting.google.com>...
> > Hi!
> >
> > I was told technically it is not a good idea to switch on AUTOEXTEND
> > for all tablespaces except for SYSTEM. Practically as a junior Oracle
> > DBA I am really allured to switch it on for all tablespaces.
> >
> > Could anybody explain to me why AUTOEXTEND will cause fragmentation or
> > I/O contention?
> >
> > Thanks in advance.
>
> The main problem is that you will loose control of your disk. In other
> words, once the autoextending tablespaces have completely filled it up
> (because you didn't monitor the growth,as you didn't want to be
> annoyed by error messages) you are in really deep shit, especially
> when bureaucrats don't want to order a disk without getting at least 6
> signatures.
> You are on your way to lazy administration and you will likely end up
> in hell.
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA

Thanks Sybrand.

You can tell my laziness for this matter comes from my history. I am a senior programmer and have been a SQL DBA for about 6 years, now they want me to pick up Oracle. You know what a SQL DBA does on daily base, not much. I think I am in my tough transition period.

Thanks again. Received on Sun Jun 15 2003 - 20:35:39 CDT