Re: # of datafiles per tablespace

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 specific 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 <ksmith2_at_myfirstlink.net> 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
>>ksmith2_at_myfirstlink.net
>>
>>--
>>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-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
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: orantdba_at_netscape.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-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).