|
在9iR2以后oracle才支持aio的,但默认它们是不支持aio,如果要打开对aio的支持,需要重新链接一下可执行文件,9iR2与10g中打开aio选项的方式也是不同,所以需要注意,还有就是初始化参数中,对于data file使用raw devices或file system,那参数的设置也稍微有些差异。
9iR2: 1) cd to $ORACLE_HOME/rdbms/lib a) make -f ins_rdbms.mk async_on b) make -f ins_rdbms.mk ioracle 2) Parameter settings in init.ora for raw devices: set 'disk_asynch_io=true' (default value is true) 2) Parameter settings in init.ora file for filesystem files: a) set 'disk_asynch_io=true' (default value is true) b) set 'filesystemio_options=asynch' 10gR1/10gR2: 1.1) In RHEL 2.1 Requires libaio packages. libaio-0.3.13-3.i386.rpm libaio-devel-0.3.13-3.i386.rpm 1.2)make option make PL_ORALIBS=-laio -f ins_rdbms.mk async_on 1.3)In init.ora file add following option. for raw devices disk_asynch_io=true (this is default option) for file system filesystemio_options =asynch disk_asynch_io=true (this is default option) 2.1) In RHEL 3 Requires libaio packages. (RHEL 3 Update 2) libaio-0.3.96-3.i386.rpm libaio-devel-0.3.96-3.i386.rpm 2.2) Make Option make PL_ORALIBS=-laio -f ins_rdbms.mk async_on 3.3)In init.ora file add following option. for data files on raw devices disk_asynch_io=true (this is default option) for data files on file system filesystemio_options =asynch disk_asynch_io=true (this is default option) 3.1) In RHEL 4 Requires libaio packages. (RHEL 4 Update 3) libaio-devel-0.3.105-2.i386.rpm libaio-0.3.105-2.i386.rpm 3.2) Make Option make PL_ORALIBS=-laio -f ins_rdbms.mk async_on 3.3)In init.ora file add following option. for data files on raw devices disk_asynch_io=true (this is default option) for data files on file system filesystemio_options =asynch disk_asynch_io=true (this is default option)
|