WARNING:Could not lower the asynch I/O limit
oracle 10.2.0.5+rac
/u01/admin/szrun/udump/szrun1_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: szgjjdb1
Release: 3
Version: 5
Machine: 00C292E64C00
Instance name: szrun1
Redo thread mounted by this instance: 1
Oracle process number: 42
Unix process pid: 1110474, image:
*** 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
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] | |||||
| |||||
修改時間 31-AUG-2010 型別 PROBLEM 狀態 MODERATED |
In this Document
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
Changes
Recently 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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-676789/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【轉】WARNING:Could not lower the asynch I/O limit 錯誤MIT
- WARNING:Could not lower the asynch I/O limit 錯誤解決MIT
- WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O.MITSQL
- WARNING:Could not increase the asynch I/O limit to 164 for SQL direct I/OMITSQL
- WARNING:Could not increase the asynch I/O limit to 224 for SQL direct I/O.MITSQL
- expdp匯出時卡死 Could not increase the asynch I/O limit to for SQL direct I/OMITSQL
- not lower asynch I/O limit to 224 for SQL dire I/O Aft Upgrad 10.2.0.5_1155445.1MITSQL
- expdp匯出時卡死 Could not increase the asynch I/O limit to XXX for SQL direct I/OMITSQL
- Warning: OS async I/O limit 128 is lower than recovery batch 1024MITBAT
- not set asynch I/O limit to nnnn for SQL directo I/O.It is set to 200_848859.1MITSQL
- linux 下filesystemio_options disk_asynch_io 導致的I/O效能下降Linux
- ORA-30052: invalid lower limit snapshot expressionMITExpress
- Veritas Quick I/O and Cached Quick I/OUI
- 計算機I/O與I/O模型計算機模型
- I/O埠和I/O記憶體記憶體
- Could Not Save Service Alias: TNS-04415 : File I/O Error [ID 798206.1]Error
- Java(8)I/OJava
- 【java】I/O流Java
- Java I/O流Java
- 檔案I/O
- C++ I/OC++
- I/O基礎
- java的I/OJava
- Python教程:精簡概述I/O模型與I/O操作Python模型
- Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5LAI
- goldengate extract abended unable to queue I/O, I/O beyond file sizeGo
- 【面試】I/O 複用面試
- Java 非同步 I/OJava非同步
- 網路I/O模型模型
- 系統級 I/O
- JAVA I/O系統Java
- GDAL並行I/O並行
- 優化磁碟I/O優化
- 從資料庫層面理解:隨機 I/O & 順序 I/O資料庫隨機
- lightdb WARNING: could not establish connection after 30000 ms
- Linux下的5種I/O模型與3組I/O複用Linux模型
- 流?I/O 操作?阻塞?epoll?
- python 非同步 I/OPython非同步