遇到WARNING:Could not lower the asynch I/O limit to 170 for SQL direct I/O. It is
來源：程序員人生 發布時間：2015-05-20 10:54:18 閱讀次數：3242次
該warning是在j001.trc文件里邊的
平臺信息以下（該信息也是來源于j001.trc文件）
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1
CPU : 64 - type 8664, 32 Physical Cores
搜索mos,得到以下文章：
'Warning:Could not Lower the Asynch I/O Limit to 224 for SQL direct I/O. It is set to ⑴' After Upgrading To 10.2.0.5 (Doc ID 1155445.1)
Bug 9772888 - Needless "WARNING:Could not lower the asynch I/O limit to .. for SQL direct I/O It is set to ⑴" messages (Doc ID 9772888.8)
在上述文章中，該warning被定位為bug：
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
固然，該bug并不是針對windows平臺：
| Product (Component) |
Oracle Server (Rdbms) |
| Range of versions believed to be affected |
Versions >= 10.2.0.5 but BELOW 12.1 |
| Versions confirmed as being affected |
|
| Platforms affected |
Generic (all / most platforms affected) |
解決該bug的方法：
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.
| This issue is fixed in |
- 12.1.0.1 (Base Release)
- 11.2.0.2 (Server Patch Set)
- 10.2.0.5.2 Database Patch Set Update
- 10.2.0.5 Patch 1 on Windows Platforms
|
這個案例也說明：打psu（非windows平臺）或bundle patch（windows平臺）的重要性！
生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
