Oracle-L: RE: # of datafiles per tablespace

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Tue, 05 Mar 2002 05:48:27 -0800
Message-ID: <F001.0041F709.20020305054827@fatcity.com>

However, if all the disks that you are spreading the files out among are stripped you lose that advantage do you not? We strip then mirror, so we have multiple big strips and partition against that.

-----Original Message-----

Rajesh.Rao_at_jpmchase.com
Sent: Monday, March 04, 2002 9:48 PM
To: Multiple recipients of list ORACLE-L

If it were a data or an index tablespace, laying out a tablespace across multiple datafiles could help in striping data or partitioning. And as Kirti said, could be to balance the I/O across multiple disks.

Raj

                    "Deshpande, Kirti"
                    <kirti.deshpande_at_ve        To:     Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
                    rizon.com>                 cc:
                    Sent by:                   Subject:     RE: # of
datafiles per tablespace
                    root_at_fatcity.com


                    March 04, 2002
                    10:33 PM
                    Please respond to
                    ORACLE-L

Other than I/O load balancing.. I can't see any other reason.

But again, why those tiny 50MB files?
Are these on the same disk? I hope not..

If there is no I/O bottleneck issues, I would build just one 700MB file. And then monitor how it works out..

Kirti

-----Original Message-----

Sent: Monday, March 04, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Rajesh.Rao_at_jpmchase.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

--

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