在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)
阅读(1138) | 评论(0) | 转发(0) |