Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Asynchronous commit - wait or no wait 10GR2

Re: Asynchronous commit - wait or no wait 10GR2

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 3 Oct 2007 15:09:48 +0300
Message-ID: <6e49b6d00710030509s23744db9t7a1b42c1e653e03f@mail.gmail.com>


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
Received on Wed Oct 03 2007 - 07:09:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US