RE: Async and Direct I/O On Solaris using VXFS
- From: rajesh koppada <xrajx@xxxxxxxxxxx>
- To: <kylelf@xxxxxxxxx>, Posting <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2011 15:02:12 +0000
I was following the below link and tracing the systems calls ,
http://www.pythian.com/news/22727/how-to-confirm-direct-io-is-getting-used-on-solaris/
We are using oracle version 11.2.0.2 on VXFS file systems on Sun solaris
4294/1: open("/users/oracle/undofile/undotbs01.dbf", O_RDWR|O_DSYNC) =
10
4294/1: ioctl(257, (('V'<<24)|('X'<<16)|('F'<<8)|1), 0x00000004) = 0
any idea how to intepert this ioctl arguments ?? Just to ensure we are getting
Direct I/O on VXFS file systems.
Date: Mon, 27 Jun 2011 15:17:12 -0700
Subject: Re: Async and Direct I/O On Solaris using VXFS
From: kylelf@xxxxxxxxx
To: xrajx@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxxxx>
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
Other related posts:
