| 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
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" <HANDM_at_polaroid.com>
Sent by: root_at_fatcity.com
09/26/2002 08:33 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.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). Received on Fri Sep 27 2002 - 12:46:02 CDT
 |
 |