遇到WARNING:Could not lower the asynch I/O limit to 170 for SQL direct I/O. It is set to -1
来源:互联网 发布:淘宝买家怎么升级 编辑:程序博客网 时间:2024/05/17 01:35
该warning是在j001.trc文件里边的
平台信息如下(该信息也是来源于j001.trc文件)
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsWindows 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 -1' 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 -1" 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/OSame behavior appears and on the same platform 10.2.0.5
当然,该bug并非针对windows平台:
- 11.2.0.1
- 10.2.0.5
解决该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平台)的重要性!
0 0
- 遇到WARNING:Could not lower the asynch I/O limit to 170 for SQL direct I/O. It is set to -1
- Oracle Bug: WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1
- WARNING:Could not increase the asynch I/O limit to 64 for SQL direct I/O. It is set to 0
- Warning: Some pins have incomplete I/O assignments. Refer to the I/O Assignment Warnings report for
- "Warning: OS async I/O limit 128 is lower than recovery batch 1024" in Alert log (文档 ID 471846.1)
- How to Tell if the I/O of the Database is Slow - 1
- Throttle The Disk I/O Rate: Limit disk I/O For rsync Tool
- André Carvalho: 使用CGroups限制I/O(Using cgroups to limit I/O)
- Thread Pool and Asynch I/O
- Direct I/O
- 解决PHP Warning: strftime(): It is not safe to rely on the system's timezone set
- How to Tell if the I/O of the Database is Slow - 2
- How to set the I/O Queue depth on VMware ESX servers?
- Introduction to Java I/O
- Use exceptions to watch for and handle I/O errors.
- Use exceptions to watch for and handle I/O errors.
- Code Jam to I/O for Women 2016【上】
- Oracle and Direct I/O
- Android Studio--Gradle多渠道打包
- springmvc学习笔记(29)——HandleException处理异常
- 【J2EE浅析】——EJB
- UVa1602 - Lattice Animals
- 【转载】Linux下用dd命令扇区读写SD卡
- 遇到WARNING:Could not lower the asynch I/O limit to 170 for SQL direct I/O. It is set to -1
- 大量数据的情况下,找出最热门的TOP N 词汇
- 让生活过得更像生活,活泼的屌丝。
- (2014.4.29)server/client代码
- TextView代码设置一个TopDrawable
- 第一届省赛 Phone Number
- oracle数据库死锁解决方法
- Android Studio--Gradle脚本初识
- AC自动机学习记录