Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
Received on Fri Aug 18 2000 - 13:19:18 CDT