this is the first time I've NOT figured the file size the AR way :)
- Jared.Still_at_radisys.com 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" <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).
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: wisernet100_at_yahoo.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 - 15:03:33 CDT