Home » RDBMS Server » Performance Tuning » splitting datafiles
splitting datafiles [message #64769] Mon, 26 January 2004 03:50 Go to next message
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
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
Previous Topic: how to increase max_processes?
Next Topic: control tracefiles for other sessions
Goto Forum:
  


Current Time: Thu Mar 28 19:45:47 CDT 2024