Oracle should always be opening the files with O_DSYNC.
See http://www.opensolaris.org/jive/thread.jspa?messageID=7037 There's a good point there about the Archiver -- ArchiveLog files should not be on Direct I/O filesystems.
This thread leads me to a question. Does the Unix syncer come into play when direct IO is used? I believe it does with most FS caching, which means that even synchronous writes can't really be guaranteed, doesn't it? At least that's what I was lead to believe...
Rich -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hemant K Chitale Sent: Tuesday, September 26, 2006 9:28 AM To: juancarlosreyesp@xxxxxxxxx; Oracle-L Freelists Subject: Re: Important note about asynchronous commit
Hemant K Chitale http://web.singnet.com.sg/~hkchital