Re: Viewing filesystemio options
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Nov 2004 20:34:02 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
