Q: oracle data files & performance
- From: "Amihay Gonen" <AmihayG@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 31 Jul 2005 20:34:33 +0300
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,
Other related posts:
