| splitting datafiles [message #64769] |
Mon, 26 January 2004 03:50  |
Mat
Messages: 22
Registered: November 2001
|
Junior Member |
|
|
Hi there,
I wonder if it my response times will decrease if I split a 20Gb datafile into ten 2Gb datafiles (located on a single volume) ? Is there a critical size for a datafile in terms of performance ? (unfortunately we can not use partitionning...)
Thanks for your ideas,
Mathias
|
|
|
|
| Re: splitting datafiles [message #64770 is a reply to message #64769] |
Mon, 26 January 2004 05:20  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Nope,it shouldnt. Infact if you are using ordinary filesystem ( as opposed to Raw devices or Veritas or Direct I/O),the performance should increase by splitting the 20GB datafile into 10 2GB files due to reduced UFS writer locks.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
