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
[EMAIL PROTECTED] 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?
--- Kimberly Smith <[EMAIL PROTECTED]> wrote: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.
___________________________
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
