| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace (datafile reducing)
!! Please do not post Off Topic to this List !!
Datafile sizing is also dependent on the size of your db. I use 10gb datafile size's for a 1tb database.
>>> cspence_at_FuelSpot.com 09/14/01 09:50AM >>>
!! Please do not post Off Topic to this List !!
Generally more smaller data files is better than fewer larger ones.
There is no performance problem with having 10 200Mb data files rather than 1 2gb data file. In fact, using 10 200mb data files will help a little when it comes to file locking.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Thursday, September 13, 2001 8:27 PM
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to this List !!
Hello DBAs
I have a tablespace , who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to combine them all to one single large datafile of 2gig.
How do I get rid off all those datafiles and ghet them in one large datafiles??
Any help in this regard
Thank you very much
Kishore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore INET: mcgoracle_at_yahoo.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: Christopher Spence INET: cspence_at_FuelSpot.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: 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 Fri Sep 14 2001 - 09:37:31 CDT
 |
 |