| 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
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C00B9F.4E71BCDA
Content-Type: text/plain;
charset="iso-8859-1"
And, unless I am sorely wrong, it just extends the same file. So, one of the dangers of autoextend is that it will extend the file past the limit your OS supports for file sizes.
-----Original Message-----
From: Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com]
Sent: Monday, August 21, 2000 2:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: autoextend system
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 <http://mail.yahoo.com/> - Free email you can access from anywhere! ------_=_NextPart_001_01C00B9F.4E71BCDA Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.3017.1000" name=GENERATOR></HEAD> <BODY> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815534118-21082000>And, unless I am sorely wrong, it just extends the same file. So, one of the dangers of autoextend is that it will extend the file past the limit your OS supports for file sizes.</SPAN></FONT></DIV> <BLOCKQUOTE> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com]<BR><B>Sent:</B> Monday, August 21, 2000 2:48 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: autoextend system<BR><BR></DIV></FONT> <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_at_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_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>__________________________________________________<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_at_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>Received on Mon Aug 21 2000 - 13:40:32 CDT
 |
 |