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

 

如果在alert log有如下資訊：

 

*** 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

 

原因：

 

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

 

 

該Bug 影響的2個版本：

10.2.0.5

11.2.0.1

 

在如下版本已經修複：

12.1 (Future Release)

11.2.0.2 (Server Patch Set)

10.2.0.5.2 Patch Set Update

10.2.0.5 Patch 1 on Windows Platforms

 

 

       之前也將DB 升級到10.2.0.5了。 還沒有遇到這個bug。 不過論壇裡有人已經遇到了。 小關注一下。

 

 

 

 

 

---------------------------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

網上資源： http://tianlesoftware.download.csdn.net

相關視頻：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(滿); DBA2 群：62697977(滿) DBA3 群：62697850(滿)  

DBA 超級群：63306533(滿); DBA4 群： 83829929 DBA5群： 142216823

聊天 群：40132017  聊天2群：69087192

--加群需要在備忘說明Oracle資料表空間和資料檔案的關係，否則拒絕申請