| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: autoextend system
--0-1189641421-966879368=:12643
Content-Type: text/plain; charset=us-ascii
Datafiles are exetended in the same filesytem they currently exist in
Gillian M <zmkj04_at_yahoo.com> wrote:
I am also concerned about the 'autoextend' feature. I
prefer more control over my databases.
I was always unsure if the database would know which filesystem to use for the datafile. I mean, where would it extend it to?
The manuals never give details.
Thanks
Gillian
-- Author: =?iso-8859-1?q?Gillian=20M?= INET: zmkj04_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). --------------------------------- Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! --0-1189641421-966879368=:12643 Content-Type: text/html; charset=us-ascii <P> Datafiles are exetended in the same filesytem they currently exist in<BR> <P> <B><I>Gillian M <zmkj04_at_yahoo.com></I></B> wrote: <BR> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">I am also concerned about the 'autoextend' feature. I<BR>prefer more control over my databases. <BR><BR>I was always unsure if the database would know which<BR>filesystem to use for the datafile. I mean, where<BR>would it extend it to?<BR><BR>The manuals never give details.<BR><BR>Thanks<BR>Gillian<BR><BR>--- Lyall Barbour <LBARBOUR_at_STANFORD.EDU>wrote: ><BR>Personally I dislike the autoextend feature. I like<BR>> to watch my database <BR>> and be a little more proactive to tablespaces<BR>> getting out of hand. I also <BR>> don't like having a million files all over the OS,<BR>> which autoextend could <BR>> possibly give you if you're not careful.<BR>> <BR>> In other words, I don't like it.<BR>> <BR>> Lyall Barbour<BR>> <BR>> At 10:25 AM 8/18/00 -0800, you wrote:<BR>> >I am ready to create a database, can anyone tell<BR>> >me if there are an! y advantages or disadvantages<BR>> >to using autoextend option<BR>> >for the system this is what I'd plan to use.<BR>> ><BR>> >create database PROTO<BR>> > maxinstances 8<BR>> > maxlogfiles 32<BR>> > maxdatafiles 500<BR>> >datafile<BR>> > '/oracle_app/files/PROTO/PROTOsys01.dbf' size<BR>> 100M;<BR>> ><BR>> >Thanks for any/all comments.<BR>> >Steff Gonos<BR>> ><BR>> ><BR>> ><BR>> ><BR>> >=====<BR>><BR>>*******************************************************<BR>> > A day without sunshine is like, well, night.<BR>><BR>>*******************************************************<BR>> ><BR>> >Steff Gonos<BR>> >steff_gonos@yahoo.com<BR>> ><BR>> >__________________________________________________<BR>> >Do You Yahoo!?<BR>> >Send instant messages & get email alerts with<BR>> Yahoo! Messenger.<BR>> >http://im.yahoo.! com/<BR>> >--<BR>> >Author: Steff Gonos<BR>> > INET: steff_gonos_at_yahoo.com<BR>> ><BR>> >Fat City Network Services -- (858) 538-5051 <BR>> FAX: (858) 538-5051<BR>> >San Diego, California -- Public Internet<BR>> access / Mailing Lists<BR>><BR>>--------------------------------------------------------------------<BR>> >To REMOVE yourself from this mailing list, send an<BR>> E-Mail message<BR>> >to: ListGuru_at_fatcity.com (note EXACT spelling of<BR>> 'ListGuru') and in<BR>> >the message BODY, include a line containing: UNSUB<BR>> ORACLE-L<BR>> >(or the name of mailing list you want to be removed<BR>> from). You may<BR>> >also send the HELP command for other information<BR>> (like subscribing).<BR>> <BR>> -- <BR>> Author: Lyall Barbour<BR>> INET: lbarbour_at_stanford.edu<BR>> <BR>> Fat City Network Services -- (858) 538-5051 FAX:<BR>> (858) 538-5051<BR>> San Diego, Califor! nia -- Public Internet<BR>> access / Mailing Lists<BR>><BR>--------------------------------------------------------------------<BR>> To REMOVE yourself from this mailing list, send an<BR>> E-Mail message<BR>> to: ListGuru@fatcity.com (note EXACT spelling of<BR>> 'ListGuru') and in<BR>> the message BODY, include a line containing: UNSUB<BR>> ORACLE-L<BR>> (or the name of mailing list you want to be removed<BR>> from). You may<BR>> also send the HELP command for other information<BR>> (like subscribing).<BR><BR><BR>__________________________________________________<BR>Do You Yahoo!?<BR>Send instant messages & get email alerts with Yahoo! Messenger.<BR>http://im.yahoo.com/<BR>-- <BR>Author: =?iso-8859-1?q?Gillian=20M?=<BR>INET: zmkj04@yahoo.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>----------------------------------------------------------! ----------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>Received on Mon Aug 21 2000 - 12:36:08 CDT
 |
 |