RE: Datafile size on NT or 2000

From: Tony Johnson <Tony_Johnson_at_Trimble.com>
Date: Thu, 05 Sep 2002 15:10:10 -0800
Message-ID: <F001.004C9495.20020905151010@fatcity.com>

There used to be a bug that caused problems with files on NT 4g or more in size. I've standardsized on 3999 meg as a result of this.

Tony Johnson					Email  : tony_johnson_at_trimble.com
Manager Database Administration 		Voice  : ( 480 ) 682 - 0849
Trimble Navigation  				Cell     : ( 602 ) 363 - 7328			
7408 W. Detroit Street #100			Fax    : ( 480 ) 961 - 8801

Chandler, AZ 85226

Murphy's Data Constant:Data will be damaged in direct proportion to its value

-----Original Message-----
Sent: Thursday, September 05, 2002 2:29 PM To: Multiple recipients of list ORACLE-L

What is an ideal datafile size for a large database 10G or greater

Oracle 8.1.6

We have been using slightly under 2G and looking for an ideal size and possible reasons to use such a size

Thanks
bob

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bob Metelsky
INET: bmetelsky_at_cps92.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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: Tony Johnson
INET: Tony_Johnson_at_Trimble.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------