splitting datafiles [message #64769] |
Mon, 26 January 2004 03:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|