Re: Asynchronous commit - wait or no wait 10GR2

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_at_bjss.co.uk>:
>
>
>
> 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.

--
http://www.freelists.org/webpage/oracle-l