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<http://www.facebook.com/l.php?u=http%3A%2F%2Fyong321.freeshell.org%2Foranotes%2FDirectIO.txt&h=b8ece> - 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 >
