RE: The ill effects of NOT using direct I/O

Yes, Concurrent IO is better than Direct IO on AIX, but there is no need to set 
cio in the mount options anymore either - filesystemio_options=setall will take 
care of it in 10g+:

http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/appa_aix.htm#i631245

"With Oracle Database 10g, you can enable Direct I/O and Concurrent I/O on 
JFS/JFS2 at the file level. You can do this by setting the FILESYSTEMIO_OPTIONS 
parameter in the server parameter file to setall or directIO. This enables 
Concurrent I/O on JFS2 and Direct I/O on JFS for all data file I/O. Because the 
directIO setting disables asynchronous I/O it should normally not be used. As a 
result of this 10g feature, you can place data files on the same JFS/JFS2 file 
system as the Oracle home directory and still use Direct I/O or Concurrent I/O 
for improved performance. As mentioned earlier, you should still place Oracle 
Database logs on a separate JFS2 file system for optimal performance."

Regards,
Brandon

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rich Jesse

<snip>
Concurrent IO
<snip>

The option needs to be applied to the mount options.


Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: