Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: autoextend system
Ah, as I see now from reading the 8i docs, it's a little different then
7.3.4. Autoextend doesn't create a new datafile every time, it resizes the
datafile you have already.
What happens when you have two, or more datafiles though? What does Oracle do then? Anybody?
Lyall Barbour
At 12:21 PM 8/21/00 -0800, you wrote:
>Advantages:
>Less admin to do
>
>Disadvantages:
>See above
>
>Currently we use the autoextend feature as that is how I inherited the
>databases when our DBA left. All our tables only grow (no deletes) so it
>is a good thing for me until I learn how to do this job better. I do not
>understand a couple of the responses regarding having files all over the
>place though. Autoextend will never add any files to the OS. Autoextend is
>datafile-specific so it just allows THAT datafile to grow to the MAXSIZE
>that was specified or UNLIMITED, which is the default. Once you reach that
>MAXSIZE, you still need to manually add a new datafile for more data.
>
>In summary, if you use it, be sure to set MAXSIZE or your files can grow
>forever and can eventually corrupt your db (see Note 112011.1). Per that
>Note, you should set MAXSIZE accordingly. Other than that, the only thing
>to worry about is making sure you have all the diskspace needed if all
>your files were at their MAXSIZE. You still need to check your datafiles
>though so you know when to add another, but it can be done easily at the
>OS level now. For example, all my files except SYSTEM have MAXSIZE of 4GB
>so I can very quickly see when one is near that (it will increase in
>increments of the NEXT parameter).
>
>There isn't a good need for it if your tables don't grow or grow slowly.
>
>Michael Ray
>DBA in training
>
> >>> <ORACLE-L_at_fatcity.com> 08/19 3:05 AM >>>
> >I am ready to create a database, can anyone tell
> >me if there are any advantages or disadvantages
> >to using autoextend option
> >for the system this is what I'd plan to use.
> >
> >create database PROTO
> > maxinstances 8
> > maxlogfiles 32
> > maxdatafiles 500
> >datafile
> > '/oracle_app/files/PROTO/PROTOsys01.dbf' size 100M;
> >
> >Thanks for any/all comments.
> >Steff Gonos
>
>
>--
>Author: Michael Ray
> INET: Michael.Ray_at_trw.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Mon Aug 21 2000 - 17:00:47 CDT