Asynchronous I/O on Linux

Hi everybody,

 I want to enable asynchronous I/O
for oracle 9.2.0.3 on my redhat 7.3.
I have libaio and libaio-devel just
installed and I followed the step to
relink oracle with this option:

1. cd to $ORACLE_HOME/rdbms/lib
2. make -f ins_rdbms.mk async_on
3. make -f ins_rdbms.mk ioracle
4. Parameter settings in init.ora file for filesystem files:
5. set 'disk_asynch_io=true'
6. set 'filesystemio_options=asynch'

and then I have restarted the db (with
the right init<my_SID>.ora of course).
 The problem is this: with a

# strace -p <pid_of_dbwr>

I can still see the O_SYNC flag in the
open system call when the dbwr opens a
datafile, so it seems that the asynchronous I/O it's not enabled: it is correct? What I have to do to enable it?

P.S. yes I know it: redhat7.3 it's not a supported distribution for 9.2.0.3 but it's for learning purpose.

Thanks for your attention.

Cheers. Received on Wed May 21 2003 - 09:28:51 CDT