WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O.

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

 

Unix process pid: 3190862, image: oracle@ibm2 (m001)

*** ACTION NAME:(Auto ADDM Slave Action) 2010-08-31 15:00:45.848

*** MODULE NAME:(MMON_SLAVE) 2010-08-31 15:00:45.848

*** SERVICE NAME:(SYS$BACKGROUND) 2010-08-31 15:00:45.848

*** SESSION ID:(1695.56975) 2010-08-31 15:00:45.848

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

 

很多这个等待事件：i/o slave wait

Bug 9772888
After 10.2.0.5 installation I noticed "noisy" trace files in udump directory with the contents like this:

*** ACTION NAME:(0000011 FINISHED129) 2010-08-03 23:00:01.371
*** MODULE NAME:(rman.exe) 2010-08-03 23:00:01.371
*** SERVICE NAME:(SYS$USERS) 2010-08-03 23:00:01.371
*** SESSION ID:(17.2494) 2010-08-03 23:00:01.371
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1

This is a known bug in 10.2.0.5, some helpful MOS references:

1155445.1 ""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"
Bug 9772888: WARNING:COULD NOT LOWER THE ASYNCH I/O LIMIT TO 160 FOR SQL DIRECT I/O
At the time of writing this note interim patches exists for Linux x86-64, AIX and Solaris. No interim patch for Windows x64.

I didn't find much technical info about severity of this bug, neither on MOS nor internet. I would say it's more of an annoyance archiving those trace files than some serious bug, otherwise I would expect this bug to be listed in Known Issues section of the readme. Nevertheless, I postponed applying 10.2.0.5 on Windows x64 in production environment until interim patch is available or until Oracle support reassure me that this bug is a benign one.

Login to post comments
Wed, 08/11/2010 - 15:47 — alesk
SR opened for bug 9772888
On August 5th 2010 I opened Service request asking support to provide me interim patch for the bug for Windows x64. Right now discussion is going on (usual fun to pass tier 1 personnel), if async I/O is really turned on and if it is, could we turn it off as a workaround...then providing them some metalink notes, ...as I said we have fun ;-). I hope I'll be back with some good news. Fingers crossed.

Login to post comments
Tue, 08/24/2010 - 10:30 — alesk
Fix for bug 9772888
Oracle support notified me that fix for the bug 9772888 will be included in Patch 1 for 10.2.0.5. At the time of this writing the release date for patch 1 is not yet known, according to MOS note 161549.1 Bulletin : Oracle Database Server and Networking Patches for Microsoft Platforms.

Login to post comments 
 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-672249/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8102208/viewspace-672249/