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-----
[EMAIL PROTECTED]
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@ve To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
rizon.com> cc:
Sent by: Subject: RE: # of
datafiles per tablespace
[EMAIL PROTECTED]
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
[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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
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).
