Oracle出现WARNING:Could not lower the asynch I/O limit

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:1080

Oracle出现WARNING:Could not lower the asynch I/O limit

oracle 10.2.0.5+rac数据库出现以下报错:

/u01/admin/sz/udump/sz1_ora_1110474.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/db10gr2
System name: AIX
Node name: szdb1
Release: 3
Version: 5
Machine: 00C292E64C00
Instance name: sz1
Redo thread mounted by this instance: 1
Oracle process number: 42
Unix process pid: 1110474, image: mailto:oracle@szdb1]oracle@szdb1
*** 2010-10-26 14:46:32.437
*** ACTION NAME:() 2010-10-26 14:46:32.433
*** MODULE NAME:(JDBC Thin Client) 2010-10-26 14:46:32.433
*** SERVICE NAME:(szrun) 2010-10-26 14:46:32.433
*** SESSION ID:(1036.56615) 2010-10-26 14:46:32.433
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
*** 2010-10-26 14:56:04.497
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
经过查metalink,是10.2.0.5的bug

[table=98%]
[td=4,1]WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1" After Upgrading To 10.2.0.5 [ID 1155445.1][td=2,1]
[td=6,1]
[td=2,1,25%][td=3,1,50%][i]修改时间 31-AUG-2010 [i]类型 PROBLEM [i]状态 MODERATED

In this Document
[size=-1]Symptoms
Changes
Cause
Solution
References

[size=-1][i]This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.5 and later [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms
Warning below appears after upgrading to 10.2.0.5

*** SESSION ID:(538.48) 2010-07-15 08:41:30.649

WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1
WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1
WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1
WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1

ChangesRecently upgraded to 10.2.0.5.
Cause
This seems due to bug 9772888 10.2.0.5 RDBMS 10.2.0.5 BUFFER CACHE PRODID-5 PORTID-23 Abstract: WARNING:COULD NOT LOWER THE ASYNCH I/O LIMIT TO 160 FOR SQL DIRECT I/O. IT IS SE
Same behavior. appears and on the same platform. 10.2.0.5

Solution
1. Upgrade to Oracle 11.2 and install on top patchset 11.2.0.2.0 (or higher version patchset) where issue is fixed

OR

2. Install one-off patch on top of 10.2.0.5.0 if available to your platform.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】