direct reads and writes on Solaris

From: Dan Norris <dannorris_at_dannorris.com>
Date: Thu, 24 Jan 2008 14:14:15 -0800 (PST)
Message-ID: <575090.6776.qm@web35403.mail.mud.yahoo.com>


Can someone help me interpret this set of data correctly?

The (vxfs) filesystem is mounted with these options:

/db51 on /dev/vx/dsk/oracledg/db18 read/write/setuid/mincache=direct/delaylog/largefiles/ioerror=mwdisable/dev=3ac36c1

This is 9.2.0.8 on Solaris 9 (V490, Generic_122300-07) with VxFS 4.1.

I have the following line in a truss of a dedicated server process:

open("/db51/oradata/tccrt1/member_questions_d01.dbf", O_RDWR|O_DSYNC) = 9

I also have the following settings in the DB:

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io                       boolean     TRUE
filesystemio_options                 string      ASYNCH

The question(s):
I was expecting to see O_DIRECT in there somehow, but I'm thinking that maybe that's just on Linux, not Solaris. I don't see O_DIRECT listed in the open(2) manual page. I am also wondering if filesystemio_options needs to be "setall" instead of the current setting of "ASYNCH" in order to achieve directIO. Or, am I looking at the wrong thing to determine if directIO is enabled?

Thanks in advance!

Dan

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 24 2008 - 16:14:15 CST

Original text of this message