Re: Asynchronous commit - wait or no wait 10GR2
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: john.hallas@xxxxxxxxxx
- Date: Wed, 3 Oct 2007 15:09:48 +0300
Probably this article by Connor McDonald will explain you this behaviour
http://www.oracledba.co.uk/tips/lgwr_dilemma.htm
A while ago I did almost exactly the same test and was as suprised as you ;)
Gints Plivna
http://www.gplivna.eu
2007/10/3, John Hallas <john.hallas@xxxxxxxxxx>:
>
>
>
> In 10GR2 there is an option to commit immediate nowait which allows the
> commit to return before the redo is persistent in the redo log. This is not
> the default. The default commit remains as commit write immediate wait.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
