one option is brute force :-P create a very big table and full scan it, direct i/o will be slower because filesystem buffer would help in this case! -- LSC On Nov 21, 2007 10:11 AM, DBA Deepak <oracle.tutorials@xxxxxxxxx> wrote: > Hi John, > > Sorry for the late response. Even after mounting the filesystem with > "forcedirectio" option am unable to see a non-zero value as the third > parameter value to the ioctl() calls. I did the same experiment as > mentioned in your previous mail. > > Would you please tell is there any alternative to verify whether the > system is using directio or not? > > Regards, > > Deepak > > On Oct 18, 2007 12:45 PM, John Hallas <john.hallas@xxxxxxxxxx> wrote: > > > > > > > > Have the filesystems been mounted with direct_io option? > > > > > > ________________________________ > > > > > > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] > > On Behalf Of DBA Deepak > > Sent: 17 October 2007 19:39 > > To: John Hallas > > Cc: oracle-l > > Subject: Re: filesystemio_options option on solaris 9 sparc 64-bit > (Oracle > > 10g) > > > > > > > > > > > > Hi John, > > > > > > > > Thanks for your help. In my environment filesystemio_options is set to > > SETALL > > > > > > > > > > > > Still it is not using directIO as per your test. My server is sparc > Solaris > > 9, 64 bit with Oracle 10.2.0.3. > > > > > > > > > > > > Can you please help me in troubleshooting the same. Am I missing > anything? > > > > > > > > > > > > ________________________________ > > > > BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW. > > Registered in England with company number 2777575. > > http://www.bjss.co.uk > > > > > > > > > > -- > Regards, > > Deepak > Oracle DBA > -- > //www.freelists.org/webpage/oracle-l > > >