今天expdp导出时卡死不跟踪文件中出现类似下面的错误内容:
WARNING:Could not increase the asynch I/O limit to 3328 for SQL direct I/O. It is set to 128
是oracle的BUG,编号:9949948,只发生在10.2.0.5.0和11.2.0.1.0,解决方法有2种,一种是在操作系统层面修改相关参数另一种方法就是打补丁
MOS上的相关内容为:Warning:Could Not Increase The Asynch I/O Limit To XX For Sql Direct I/O [ID 1302633.1]
Oracle Server - Enterprise Edition - Version:
filesystemio_options = none
[root@hnz ~]# cat /proc/sys/fs/aio-max-size
cat: /proc/sys/fs/aio-max-size: No such file or directory
[root@hnz ~]# cat /proc/sys/fs/aio-max-nr
The aio-max-size kernel parameter doesn't exist in the 2.6.x Linux
This feature is now "automatic" in the 2.6.x kernel, based on the
physical capabilities of the disk device driver.
This should mean that the Linux Kernel is ready to perform. ASYNC
All install requirements should be met.
To ensure ASYNC I/O can be performed by Oracle Database you need to
verify or set the following parameters in the Database:
sql>alter system set disk_asynch_io=true scope=spfile;
sql> alter system set filesystemio_options=setall scope=spfile;
Then shutdown and startup the database and check if the warning
An HCVE report (refer to Note 250262.1) should report no remaining
If the above doesn't resolve the problem, then increase
COULD NOT INCREASE THE ASYNCH I/O LIMIT TO NNN FOR SQL DIRECT I/O.
BUG:9772888 - WARNING:COULD NOT LOWER THE
ASYNCH I/O LIMIT TO 160 FOR SQL DIRECT I/O. IT IS SE
NOTE:205259.1 - Howto Enable Asynchoronous I/O
NOTE:225751.1 - Asynchronous I/O (aio) on
RedHat Advanced Server 2.1 and RedHat Enterprise Linux 3
[oracle@hnz ~]$ sqlplus /as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Oct 22
Copyright (c) 1982, 2010, Oracle. All Rights
10g Enterprise Edition Release 10.2.0.5.0 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application
SQL> show parameter disk_asynch_io
------------------------------------ ----------- ------------------------------
disk_asynch_io boolean TRUE
SQL> show parameter filesystemio_options
------------------------------------ ----------- ------------------------------
filesystemio_options string none
SQL> alter system set filesystemio_options=setall scope=spfile;
修改内核参数的值:aio-max-nr设置太低,推荐设置为fs.aio-max-nr= 3145728。修改参数使用/sbin/sysctl -p重新加载参数后,重启数据库即可
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26015009/viewspace-774840/,如需转载,请注明出处,否则将追究法律责任。