漫谈log file sync

Naviler

不错，今天真正理解了group commit

m277498501

http://www.itpub.net/thread-1760165-1-1.html

LGWR cannot write to disk to commit these transactions until its previous write completes. Upon completion, LGWR can write the list of redo entries of waiting transactions (not yet committed) in one operation.

m277498501

http://www.itpub.net/thread-1760165-1-1.html

LGWR cannot write to disk to commit these transactions until its previous write completes. Upon completion, LGWR can write the list of redo entries of waiting transactions (not yet committed) in one operation.

jackyjlc

支持楼主原创。

vict_

wuleeford

收藏了，谢谢

vmcd_gg

12c之后 很多问题不再是问题

malavons

正好在研究这个问题

xujie0915

支持原创，没看懂。

wll1017

你好，我有个疑问，对于 产生log file sync 等待事件的原因是commit比较频繁，如果不知道是那个应用产生的，如果查找comit比较频繁的语句？