But is it required to mount the file system with direct_io option? I think the parameter takes care of the same. If we mount the file system with direct_io option probably we do not need to set the said oracle parameter. Please correct me if am missing anything. BTW have not mounted the file system with direct_io option. On 10/18/07, 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