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_at_gmail.com> 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_at_bjss.co.uk> wrote:
> >
> >
> >
> > Have the filesystems been mounted with direct_io option?
> >
> >
> > ________________________________
> >
> >
> > From: oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]
> > 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 21 2007 - 04:38:22 CST
