RE: Datafile size on NT or 2000

The 4GB problem on NT was ONLY where it would autoextend over a 4gb boundary (eg 4,8,12,16...). You can manually size the datafile whatever size you wish - ie you can cross the boundary manually.

However, one place I recently contracted at were determined to cold backup their 120GB data warehouse system and it was decided to zip the datafiles as part of the backup process. Zip only handles files up to 4GB in size so they standardised on 4000MB datafiles (zipped down they reduced to 80mb - yep huge allocation, little data - it takes all sorts!) - guess who had to rebuild the data warehouse to these specs! ;-(

So, on deciding your datafile size, be aware of various issues - mostly regarding the management of these files. I would agree with my previous client that 4gb (or near) is probably the biggest I'd go on windows systems unless there's a *specific* and good reason to go higher.

Lewis Bishop

---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - lewis.bishop_at_woolwich.co.uk


-----Original Message-----
Sent: 06 September 2002 00:10
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
----------------------------------------------------------------------

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


The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at ADMINISTRATOR_at_WOOLWICH.CO.UK

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.



-- 

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


-- 

Author: Bishop Lewis
  INET: Lewis.Bishop_at_woolwich.co.uk

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