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).
