| 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: # of datafiles per tablespace
Using Sql Backtrack for backups, you are able execute the backups of multiple datafiles in parallel. Therefore, it will be faster to backup 4-1g files rather than 1-4g file if you have the necessary hardware in place.
4:58 AM
PST Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:
Hi Kathy,
The only thing I can think of for your original question is a bad guess on the
file size. They
guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace,
ran out again
added 50 mb again. never ran out again.
Reading other dba's minds is so much fun :-)
John
ksmith2_at_MYFIRSTLINK.NET wrote:
That being said is there anything wrong with having one 4G data file for a tablespace. I personally cannot think of any. There were the days when 2G was the limit but that sure isn't the case anymore.
The only thing I can think of is for backups. However, I am always going to backup on at least the tablespace level so if I have one file or multiple files I still need to get them all. I don't know if RMAN has some special feature that turns out it makes sense to backup just one data file of a tablespace that has multiple data files but I sure can't think of any good reason.
I just randomly picked RBS but I am seeing the same case on data tablespaces as well.
-----Original Message-----
Carmichael
Sent: Monday, March 04, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L
no reason. I can see creating multiple files under those conditions only because you want to keep files to a specif ic size.
Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces.
cleared up that bottleneck like a dream
other than that though.. why?
OK, I know we had the debate already but lets have another go at it.
Say you got a tablespace, lets call it RBS and its for rollbacks.
Now, for what reason would you create a 500M file and 4 50M files
for this puppy as opposed to just one file. I just cannot see the
reasoning
for this at all. None. Natta. Zilch.
So educate me please if someone out there knows a legit reason they would do this.
Lets assume for the sake of argument that disk size and mount point
size is not a limitation. Space available to me on any one mount
point
is unlimited.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: ksmith2_at_myfirstlink.net 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-LReceived on Tue Mar 05 2002 - 08:48:26 CST
(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!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: Tracy.Rahmlow_at_aexp.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).
 |
 |