admin管理员组文章数量:1576745
今天在做数据库巡检时发现等待事件asynch descriptor resize出现在TOP 5里,而且次数很高。
对于这个等待事件很陌生,百度了一下,有种说法是Bug。呵呵,既然说是Bug,那在MOS里应该有更详细的说明。
首先,来看看什么是asynch descriptor resize,在什么情况下会发生:
Wait event 'asynch descriptor resize' is waited for when the number of asynchronous descriptors reserved inside the OS kernel is being re-adjusted.
When the number of asynchronous I/O's submitted by a process has to be dynamically increased, the unix kernel is signalled to make the changes and the process will wait on 'asynch descriptor resize' . Many Unix Kernels (for example: Linux kernel) do not allow the limit to be increased when there are outstanding I/O's; all outstanding I/O's must be resolved before the limit is increased. This means that all sessions doing asynchronous I/O will wait at this time. The event is shown when the kernel wants to increase the limit and is waiting for all the outstanding I/O's to be resolved so that the increase can be implemented.
If you see this wait event often, it might be a good idea to install the fix for (unpublished) Bug: 9829397 ASYNC DESCRIPTOR RESIZE which adjusts the frequency of resize calls.
The fix for (unpublished) Bug 9829397 is included in 11.2.0.2.5, 11.2.0.3 and Oracle 12g
再看看相关bug影响的平台和数据库版本:
Affects:
Product (Component) | Oracle Server (Rdbms) |
Range of versions believed to be affected | Versions >= 11.2 but BELOW 12.1 |
Versions confirmed as being affected | 11.2.0.2 11.2.0.1 |
Platforms affected | Generic (all / most platforms affected) |
It is believed to be a regression in default behaviour thus:
Regression introduced in 11.2.0.2
Fixed:
This issue is fixed in | 12.1.0.1 (Base Release) 11.2.0.3 (Server Patch Set) 11.2.0.2.5 Database Patch Set Update 11.2.0.2.5 Grid Infrastructure Patch Set Update (GI PSU) 11.2.0.2 Bundle Patch 13 for Exadata Database 11.2.0.2 Patch 13 on Windows Platforms 11.2.0.1 Patch 15 on Windows Platforms |
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
这里数据库的版本是11.2.0.1,处在受影响的范围之内。
此bug相关描述和解决方法:
Bug 9829397 - Excessive CPU and many "asynch descriptor resize" waits for SQL using Async IO (文档 ID 9829397.8)
Description
Some queries in 11.2 may exhibit higher CPU usage than earlier
releases with many "asynch descriptor resize" waits occurring
compared to the same SQL in earlier releases.
Rediscovery Notes:
Async IO is in use.
The total time waiting for "asynch descriptor resize" is
typically very small but with very high counts. The high
wait count indicates many resizes of the number of AIO
descriptors unnecessarily wasting CPU. Workaround Disable async IO.
eg: Set DISK_ASYNCH_IO = false
References:
For more information about "asynch descriptor resize" see the following: Note:1273748.1 High Numbers of 'asynch descriptor resize' waits Note:1081977.1 Details of the "asynch descriptor resize" wait event.
Getting a Fix Use one of the "Fixed" versions listed above (for Patch Sets / bundles use the latest version available as
contents are cumulative - the "Fixed" version listed above is
the first version where the fix is included)
或者可以到bug fixes(文档 ID 1373411.1)进行搜索
该文章纯属工作记录,没有广告嫌疑,管理不要再删除,谢谢。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub/29843794/viewspace-1292494/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub/29843794/viewspace-1292494/
本文标签: asynchDescriptorresize
版权声明:本文标题:asynch descriptor resize 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/xitong/1727798792a1130584.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论