RE: Async and Direct I/O On Solaris using VXFS

Thank you , sorry i missed the platform information , We are running on Sun Soalris 5.10 , Is there a similar way we can confirm that we are doing Async i/o ? or do we need to use special products like Oracle ODM or something to get Async i/o ?  

Date: Mon, 27 Jun 2011 15:17:12 -0700
Subject: Re: Async and Direct I/O On Solaris using VXFS

From: kylelf_at_gmail.com
To: xrajx_at_hotmail.com
CC: oracle-l_at_freelists.org

The tool "directiostat" looks pretty cool for sparc, on page

http://www.solarisinternals.com/si/downloads/index.php

direct link at

http://www.solarisinternals.com/si/downloads/directiostat

On Mon, Jun 27, 2011 at 2:57 PM, kyle Hailey <kylelf_at_gmail.com> wrote:

What platform are you on? For direct I/O on solaris check out

\http://www.pythian.com/news/22727/how-to-confirm-direct-io-is-getting-used-on-solaris/

Another good reference

http://yong321.freeshell.org/oranotes/DirectIO.txt

• Kyle http://dboptimizer.com

2011/6/27 rajesh koppada <xrajx_at_hotmail.com>

Hello,  

How can i confirm that oracle will be doing Direct I/O and Asynchronous i/o with following options. Database FILESYSTEMIO_OPTIONS is set to ALL which means to use, setall - Enables both ASYNC and DIRECT IO we are using VERITAS volume manager 5.0 with VXFS filesystems(We don't have QIO or ODM) and file system mount options are set as follows mincache=direct and conovsync=direct
Will Oracle is going to use both direct i/o and asynchronous i/o with these file system options. How can we ensure i am getting direct i/o and Async i/o ? can we enable some trace or something just to ensure we are getting both?  

Thanks
Raj                                                

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