| 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: Multiple Datafiles and performance?
In my experience, spreading datafiles across volumes (specially if you are careful not to locate the a table's datafiles and its indexes datafiles in the same drive) greatly increases performance.
As for the file size, I can not say because I have not tested it, but I think it should have no real impact compared to splitting it. Reorganizing the database regularly is a better way to optimize performance.
..............................................Fermín Bernaus Berraondo
..............................................
-----Mensaje original-----
De: Dave Phillips [mailto:dphillips_at_gasper-corp.com]
Enviado el: miércoles, 06 de agosto de 2003 22:14
Para: Multiple recipients of list ORACLE-L
Asunto: Multiple Datafiles and performance?
Oracle 8.1.7.4
Win2k
What is the consensus on datafile sizing and the impact/overhead multiple datafiles have on performance?
For example, if I have one 2.5g datafile, and three 1g datafiles, and I
need more space, would it be better to increase the size of the 1g to
2g or add another 1g datafile?.
Is it better to keep them all uniform in size?
I would think having multiple datafiles that could be spread across drive volumes would be beneficial, am I wrong? (Wouldn't be the first time :)
TIA
David Phillips
Support DBA
Gasper Corp.
BAARF member #30
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dave Phillips
INET: dphillips_at_gasper-corp.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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.net
--
Author: Fermin Bernaus
INET: fbernaus_at_sammic.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Thu Aug 07 2003 - 07:05:06 CDT
 |
 |