Re: "X commits per minute": is there an absolute threshold ?

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0210310954.1080caef_at_posting.google.com>...
> sebastien.rigaud_at_b-rail.be (Sebby) wrote in message news:<5bc80fe2.0210310019.4338db36_at_posting.google.com>...
> Also make sure log_buffer is not too big.
>
> Yong Huang

I want to drop that suggestion. If there're too frequent commits, logfile writing is driven by commits anyway, not by log buffer size related mechanisms.

I want to add that Steve Adams has a good newsletter at http://www.ixora.com.au/newsletter/2001_09.htm that addresses frequent commits. He mentions that commits from within PL/SQL result in only one log file sync. That's pretty good. Why not do that?

BTW, in another message, vob (vbuehringer_at_hotmail.com) says "oracle groups commits together". It's true LGWR waits 10 centiseconds after it's posted by the first commit, to see if there's another commit request coming in. If yes, they're combined into one. But I don't think there's any way in application or database tuning we can utilize this feature.

Yong Huang Received on Thu Oct 31 2002 - 16:59:41 CST