| 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: datafile sizing question
Michael - I've done it both ways, and yes, it depends on how AR you wish to
be. You can convert everything to K and get pretty precise. Or you can
simply create the tablespace and datafile, then query the free space and
create your table accordingly. Of course LMT with uniform extents changes
the rules a bit, especially for us AR types.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
-----Original Message-----
Sent: Thursday, September 26, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
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: HANDM_at_polaroid.com
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: 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).
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: 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 Thu Sep 26 2002 - 11:23:31 CDT
 |
 |