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

Home -> Community -> Mailing Lists -> Oracle-L -> re Direct IO -- was RE: Important note about asynchronous commit

re Direct IO -- was RE: Important note about asynchronous commit

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 26 Sep 2006 23:06:03 +0800
Message-Id: <7.0.1.0.0.20060926230327.01b3cda0@singnet.com.sg>

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.

Hemant

At 10:51 PM Tuesday, Jesse, Rich wrote:
>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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
>Sent: Tuesday, September 26, 2006 9:28 AM
>To: juancarlosreyesp_at_gmail.com; Oracle-L Freelists
>Subject: Re: Important note about asynchronous commit
>
><snip>
>http://www.freelists.org/webpage/oracle-l

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 26 2006 - 10:06:03 CDT

Original text of this message

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