|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
Re: autoextend system
Re: autoextend system
- Brian
- Lyall Barbour <lbarbour_at_stanford.edu> wrote:
> 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).
>
> --
> Author: Lyall Barbour
> INET: lbarbour_at_stanford.edu
>
> 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 Tue Aug 22 2000 - 08:05:03 CDT
Original text of this message
