RE: To create a new data file or to increase a existing data

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Tue, 16 Jul 2002 08:09:22 -0800
Message-ID: <F001.00499263.20020716080922@fatcity.com>

My rule of thumb is 2gb or less for smaller databases, i.e. < 100gb and adjust higher for larger databases, e.g. 10gb datafiles for 1.3 tb database.

gene

>>> Rajendra.Jamadagni_at_espn.com 07/16/02 11:28AM >>>
We have a standard data file size of 2GB, If it is smaller (for some reason) we extend it but never > 2GB. If it is already 2GB, we add a new data file.

Raj

---

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Tuesday, July 16, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L

Denham,
You haven't mentioned tablespaces. If all five datafiles are for one tablespace, it doesn't matter much. However if each datafile is for a separate tablespace, it would be easier to increase the size of the existing datafiles. Otherwise you would need to move objects to take advantage of the sixth datafile.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145
-----Original Message-----
Hello Gurus
Which is the better policy:
Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%.
Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile?
Would appreciate any views on this point. Rgds
Denham Eva
Oracle DBA
In UNIX Land
On a quiet Night, you can hear the Windows machines reboot.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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

Received on Tue Jul 16 2002 - 11:09:22 CDT