【等待時間】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) 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) 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- wait event ---asynch descriptor resizeAI
- [重慶思莊每日技術分享]-asynch descriptor resize等待事件事件
- zt_關於wait events asynch descriptor resize_wait eventAI
- gc current request等待時間處理GC
- WinAppDriver 等待時間設定技巧APP
- buffer busy waits 平均等待時間AI
- Linux設定開機等待時間Linux
- 【實驗】RESIZE方法解決臨時表空間過大問題
- 【Oracle】-【心境】【AWR】- 等待事件的基準時間Oracle事件
- 【轉載】Selenium 處理頁面的等待時間
- Shutdown immediate命令長時間等待分析一例
- 檢視系統中各種等待時間佔用的資料庫時間比例資料庫
- 在使用alter system switch log的時候無時間限制的等待
- Mysql DDL出現長時間等待MDL問題分析MySql
- 【RESIZE】Oracle收縮表空間主要命令Oracle
- iOS - NSSortDescriptoriOS
- Laravel 登入失敗次數限制 等待時間遞增Laravel
- 原始碼解讀之FutureTask如何實現最大等待時間原始碼
- Open Feign使用方法、等待時間、日誌列印功能
- size resize與capacity reserve之間的區別
- 查詢條件為ROWNUM=1仍產生長時間等待
- windows計劃任務的“等待空閒時間”已棄用Windows
- Oracle ResizeOracle
- usb-descriptor(一 )
- usb-descriptor(二)
- usb-descriptor(三)
- Python的descriptorPython
- JavaScript resize 事件JavaScript事件
- jQuery resize事件jQuery事件
- expdp匯出時卡死 Could not increase the asynch I/O limit to for SQL direct I/OMITSQL
- 移動spa商城優化記(二)--- 減少70%的打包等待時間優化
- 指定快照時間內根據等待類查詢消耗較高的sqlSQL
- 電腦長時間停留在啟動等待介面是為什麼
- Python官方文件:Descriptor 指南Python
- 最近遇到log file sync等待時間,測試了一下非同步提交非同步
- iOS開發中可以節省50%編譯等待時間的幾個措施iOS編譯
- sql執行期間相關的等待SQL
- RDSforMySQLInnoDB行鎖等待和鎖等待超時的處理ORMMySql