Re: high log file sync wait
- From: Frits Hoogland <frits.hoogland@xxxxxxxxx>
- To: "huanshengchen@xxxxxxxxx" <huanshengchen@xxxxxxxxx>
- Date: Mon, 3 Dec 2012 08:17:17 +0100
It might be good to investigate the logwriter IO time. The foreground posts
the logwriter for the write.
Frits Hoogland
http://fritshoogland.wordpress.com
frits.hoogland@xxxxxxxxx
+31 6 53569942 <+31%206%2053569942>
Op 3 dec. 2012 om 03:56 heeft Sidney Chen <huanshengchen@xxxxxxxxx> het
volgende geschreven:
During the commit, There is communication between user session and lgwr, on
rac, SCN sync happens between the db instances. That's the wait times and
elapse time of the event "wait for scn ack". check below notes.
Bug 8220734 Long "log file sync" wait in RAC
Bug 6193945 High LGWR CPU use and long 'log file sync' latency in RAC
Troubleshooting: log file sync' Waits [ID 1376916.1]
On Sat, Dec 1, 2012 at 2:39 AM, Andreas Piesk <a.piesk@xxxxxxx> wrote:
parallel
--
Regards
Sidney Chen
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
