Rachel, that is the same thing as with money itself. Everybody keeps telling me that money isn't everything and that there are many things in life which are more important then money, but when I ask for a check to $10,000 nobody wants to give it to me. Humans are so hard to comprehend for us Vogons. Let me know if you'd like me to recite some poetry.
> -----Original Message----- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 3:18 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: datafile sizing question > > > AHA!I was going to go with 2000M so that's beautiful, 2001M would work > perfectly without going over. I don't mind "wasting" less than a meg. > > I love the logic everyone here at work has. "disk is cheap", don't > worry about it. Except every time I ask for more disk, I hear > "it's too > expensive" > > Rachel > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > Are you going with 2048M or the traditional 2000m? > > A quick & dirty way to not waste the space is to use 2001m or 2041m. > > You > > 'waste' a little space, but not much. > > > > Dan Fink > > > > -----Original Message----- > > Sent: Wednesday, September 25, 2002 10:33 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, I'm about to create some locally managed tablespaces for some > > large partitioned tables. I plan on making each datafile > 2GB, with an > > extent of 20M. > > > > What I've done other times when I use LMTs is add 64K to the file > > size, > > for the bitmap header, so that I don't waste most of an extent. But > > in > > those cases, the datafile size has been less than 2GB. > > > > We will be on Solaris 2.8, I know that the OS can handle > files larger > > than 2GB but it makes me nervous to do this. > > > > I hate to waste most of 20M just for the bitmap header. > > > > Is my thinking way off? If you've been doing this sort of sizing > > (it's > > a data warehouse, yes), what have you done? > > > > thanks! > > > > Rachel > > > > > > __________________________________________________ > > 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). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Fink, Dan > > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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).
