this is the first time I've NOT figured the file size the AR way :)
--- [EMAIL PROTECTED] wrote: > If I'm feeling particularly AR, or just want to revel in > the fact that I can do simple multiplication and addition > without error, I'll figure the datafile size to the byte. > > e.g. 200m + 64k for an LMT is 2097217536 bytes. > > On NT I tend to use NNNMm on 8.0 and NNNM > on 8i LMT's where the extent size is 4m or less, > as 4m isn't enough space to worry about wasting. > > Unless of course, I'm feeling particular AR. > > Jared > > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/26/2002 08:33 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: RE: datafile sizing question > > > I also have a just curious question. Do most interchange the values > 1000K > for 1M or 1000M for 1G? I try to be precise in my usage, but I guess > > that's > just the AR size of my personality. OK, I'll go find my pills now. > ;) By > the way, we use a maximum size of 4Gb+8k file size but, I've never > has a > reason to doubt the DEC/Compaq 64bit file systems. > > Mike > > -----Original Message----- > Sent: Thursday, September 26, 2002 5:03 AM > To: Multiple recipients of list ORACLE-L > > > We tend to use multiples of 1Gb and add 1 Mb to the file so that we > get > 2001, 10001 Mb etc > Solaris 2.8 > LMT uniform extents range from 64K to 20Mb > > John > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hand, Michael T > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).