Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Q: oracle data files & performance
Hi ,
I've received a two interesting questions from a collage of mine.
1)
If two processes are writing to the same file , will they suffer from
some conation on the file handler ?
Do you think that spreading very busy tables (has a lot of inserts from
different sessions) on different tablespaces (which will be translate
to different data files ) will have better I/O performance over one
single data file ?
I'm talking only from performance perspective , not from backup & recovery ?
2)
If we have tablespaces with several data files . Will oracle allocate
extents in a round-robin fashion between the files or will he fill one
data file and then pass to the another data file ?
Amihay Gonen
DBA,
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 31 2005 - 12:33:42 CDT
![]() |
![]() |