RE: autoextend system

While I agree that autoextend is a terrible thing in a production system (what if you run out of disk space? The word "crash" is insufficient) it can be useful in a development system when you are still working out the sizing of the objects. Definitely use the maxsize though.

Also, I wouldn't put it on the SYSTEM data files at all.

Diana Duncan

-----Original Message-----
From: Lyall Barbour [mailto:lbarbour_at_stanford.edu] Sent: Friday, August 18, 2000 3:27 PM
To: Multiple recipients of list ORACLE-L Subject: Re: autoextend system

Personally I dislike the autoextend feature. I like to watch my database and be a little more proactive to tablespaces getting out of hand. I also don't like having a million files all over the OS, which autoextend could possibly give you if you're not careful.

In other words, I don't like it.

Lyall Barbour

At 10:25 AM 8/18/00 -0800, you wrote:
>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
>
>
>
>
>=====
>*******************************************************
> A day without sunshine is like, well, night.
>*******************************************************
>
>Steff Gonos
>steff_gonos_at_yahoo.com
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: Steff Gonos
> INET: steff_gonos_at_yahoo.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