In this Document

APPLIES TO:

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

CHANGES

Recently upgraded to 10.2.0.5.

CAUSE

This seems due to 
Bug 9772888 - WARNING:COULD NOT LOWER THE ASYNCH I/O LIMIT TO 160 FOR SQL DIRECT I/O

Same behavior appears and on the same platform 10.2.0.5

SOLUTION

To implement a solution for Bug:9772888, please execute any of the below alternative solutions:

• Upgrade to 11.2.0.2 or higher
  
  OR

• Download and apply interim Patch:9772888, if available for your platform and RDBMS release. To check for conflicting patches, please use the MOS Patch Planner Tool. For the Microsoft Windows platform this issue is fixed in patch bundle 1 and higher on top of the 10.2.0.5 release. If no patch is available, file a Service Request through My Oracle Support for your specific Oracle version and platform.

REFERENCES