On Mon, Jun 27, 2011 at 08:22:41PM +0000, rajesh koppada wrote: > > 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? If you use FILESYSTEMIO_OPTIONS=setall you don't have to use vxfs mount options "mincache=direct and conovsync=direct". I'd rather avoid them. Regards Przemyslaw Bak (przemol) -- http://przemol.blogspot.com/ --------------------------------------------------- Kto da Ci kredyt, jaki chcesz? Oblicz sam w 5 min! http://linkint.pl/f29dc -- //www.freelists.org/webpage/oracle-l