Adaptive Log File sync was introduced in 11.2. The parameter controlling this feature, _use_adaptive_log_file_sync, is set to false by default in 11.2.0.1 and 11.2.0.2.
In 11.2.0.3 the default is now true. When enabled, Oracle can switches between the 2 methods:
- Post/wait, traditional method for posting completion of writes to redo log
LGWR explicitly posts all processes waiting for the commit to complete.
The advantage of the post/wait method is that sessions should find out almost immediately when the redo has been flushed to disk.
- Polling, a new method where the foreground process checks if the LGWR has completed the write.
Foreground processes sleep and poll to see if the commit is complete.
The advantage of this new method is to free LGWR from having to inform many processes waiting on commit to complete thereby freeing high CPU usage by the LGWR.
when mode switches, it will write message to LGWR trace file.
*** 2012-10-02 08:15:47.049
kcrfw_update_adaptive_sync_mode: post->poll long#=316 sync#=1719 sync=247657
poll=12382 rw=6191 rw+=13890 ack=0 min_sleep=10023
But per my experience, “Polling” mode will cause higher average wait time of “log file sync” and is not a stable LGWR algorithm for heavy OLTP workload. It can be disabled by “alter system”.
Reference
Understanding LGWR, Log File Sync Waits and Commit Performance
相关推荐
Nonlinear and Adaptive Control Design 电子书 Nonlinear and Adaptive Control Design 电子书
Sybase Adaptive Server快速入门
用python实现Adaptive Lasso
Adaptive Server 参考手册 包含有关 Sybase® Adaptive Server ® Enterprise 和 Transact-SQL® 语言的四本指南: • 构件块 介绍了 Transact-SQL 的各个组成部分:数据类型、内置 函数、全局变量、表达式、标识符...
Engineering Adaptive Software Systems: Communications of NII Shonan Meetings ISBN-10 书号: 9811321841 ISBN-13 书号: 9789811321849 Edition 版本: 1st ed. 2019 Release Finelybook 出版日期: 2019-01-15 ...
Subband Adaptive Filtering Theory and Implementation
《Nonlinear and Adaptive Control Design》是由Baba V. V. Krstic和Mihailo J. Kokotovic合著的一本经典书籍,它在自适应控制领域具有极高的权威性,尤其对于处理非线性系统的自适应控制问题提供了深入的理论与实践...
Sybase Adaptive Server Anywhere 6.0 新测有效...win7用兼容模式运行
Adaptive Optics Engineering Handbook.
Adaptive Filter Theory 5th 第五版 非扫描 高清pdf
Adaptive Filtering Primer with Matlab Adaptive Filtering Primer with Matlab Adaptive Filtering Primer with Matlab Adaptive Filtering Primer with Matlab
Adapive AUTOSAR最新标准R20-11 Adaptive AUTOSAR Adaptive Platform AUTOSAR 自适应AUTOSAR 自适应平台AUTOSAR
ASAnywhere8 Adaptive Server Anywhere
Robust Adaptive Control of Uncertain Nonlinear Systems in the Presence of Input Saturation and External Disturbance
对于AdaptiveAUTOSAR,经常会看到这句话:Writeonce,Adopteverywhere。但实际上理想很丰满,现实很骨感。毕竟ClassicPlatform(后面简称:CP)搞了这么多年大家都还没玩转,更何况这刚出没两年的AdaptivePlatform...
Robust and adaptive control
经典beamforming、自适应滤波教材matlab源代码。 Paulo S.R. Diniz编著的自适应滤波第四版(Adaptive Filtering_Algorithms and Practical Implementation 4th),源代码——IIR_Adaptive_Filters
Time Adaptive Processing for Radar
Adaptive Image Processing 2nd.pdf
adaptive sliding mode controller