FreeLists / oracle-l / RE: Q: oracle data files & performance

[oracle-l] || [Date Prev] [08-2005 Date Index] [Date Next] || [Thread Prev] [08-2005 Thread Index] [Thread Next]

RE: Q: oracle data files & performance

From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
To: <zhuchao@xxxxxxxxx>, <AmihayG@xxxxxxxxx>
Date: Mon, 1 Aug 2005 07:49:58 -0700

         −−There is the so-called single file write lock in unix.
        Raw volume/disk does not have this problem.
        and solaris/AIX 5.3 now have feature called Concurrent IO, which also 
solves this problem.
         
        I am not sure, when we have several dbwr configured, whether different 
dbwr will write to the same datafile in the same time.



that is only an issue if you are using a stock filesystem without any database
optimization such as direct IO mount options, Quick IO, Oracle Disk Manager, etc



--
http://www.freelists.org/webpage/oracle-l