Re: Viewing filesystemio options

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 25 Nov 2004 20:34:02 +0000
Message-Id: <1101414842l.7088l.1l@medo.noip.com>

Comments inline.
On 11/25/2004 03:20:27 PM, Uwe Weber wrote:
> Hello list,

>=20

> Is there are way to see through oracle itself
> which filesystemio_options it is really using,
> if the parameter is set to 'setall'. Something
> that shows me which options are used when
> opening a file?

The only way is to use truss, strace or tusc, depending on the =20 platform. What you want to see is the presence of O_NONBLOCK (O_NDELAY)=20 and O_DIRECT flags.

>=20

> And to those who know JFS2: I have trussed a
> session, it opened a file with asynch_nowait, is
> that what you would expect from a filesystem
> mounted cio?

Filesystem mounted your chief information officer and he or she did not complain? Just kidding. As far as I am aware, Oracle has no special =20 option enabling it to use "concurrent I/O". That is the same feature =20 that was available years ago in XFS, allowing "guaranteed bandwidth" I/O, but this features are non-standard and cannot be used by database software. They can, however, be utilized by AIX itself, speeding up =20 file operations.

--=20
Mladen Gogala
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 25 2004 - 14:29:41 CST