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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-773903/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-773903/