Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Q: oracle data files & performance

Q: oracle data files & performance

From: Amihay Gonen <AmihayG_at_ectel.com>
Date: Sun, 31 Jul 2005 20:34:33 +0300
Message-ID: <5A841A20A9085A4C984EADD0FF97BF3704F3C1@ectilex.ectel.com>


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-l
Received on Sun Jul 31 2005 - 12:33:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US