Now I need Dan's help. I know that the latest version
of UFS file system supports direct I/O, but I'm not sure
which incarnation lives on Solaris9. Solaris 10 has UFS2,
which does support direct I/O. If you didn't set up a parameter
and the file system that your data files are residing on doesn't
support direct I/O, then you're not doing it. My advice is to
truss oracle during startup and see whether "open" system call
uses O_DIRECT flag. You can also write a little C program which
would use O_DIRECT and see how does it work and whether it reports
any errors or not.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Roger Xu [mailto:roger_xu_at_dp7uptx.com]
> Sent: Friday, September 03, 2004 10:43 AM
> To: oracle-l_at_freelists.org
> Subject: Why "show parameter filesystemio_options" returns
> "asynche/PR2/920_64/dbs/"
>
>
> I_did_not_set_this_parameter_in_my_oracle_parameter_file.
> How_do_I_know_whether_it_is_using_direct_io_in_my_database?
> Solaris_9_plain_ufs_and_Oracle_9.2.0.4.0
> Thanks
> Roger_Xu
>
> This=20e-mail=20is=20intended=20solely=20for=20the=20person=20
> or=20entity=20=
> to=20which=20it=20is=20addressed=20and=20may=20contain=20confi
> dential=20an=
> d/or=20privileged=20information.=20Any=20review,=20disseminati
> on,=20copyin=
> g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20p
> ersons=20or=20=
> entities=20other=20than=20the=20addressee=20is=20prohibited.=2
> 0If=20you=20=
> have=20received=20this=20e-mail=20in=20error,=20please=20conta
> ct=20the=20s=
> ender=20immediately=20and=20delete=20the=20material.=20
> ____________________________________________________________________
> This=20email=20has=20been=20scanned=20for=20all=20viruses=20by
> =20the=20Mes=
> sageLabs=20Email=20Security=20System.=20Any=20questions=20plea
> se=20call=20=
> 972-721-8257=20or=20email=20your=20request=20to=20tech_support
> @dp7uptx.com=
> .
> --
> To unsubscribe -
> mailto:oracle-l-> request_at_freelists.org&subject=unsubscribe
> To
> search the
> archives - http://www.freelists.org/archives/oracle-l/
>
--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Fri Sep 03 2004 - 10:00:09 CDT
