Important note about asynchronous commit

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 26 Sep 2006 09:12:30 -0400
Message-ID: <cd4305c10609260612m6c9475aap113ee53a09c4067e@mail.gmail.com>

Hi
I want to share this because I didn't fully understood it,

Tom Kyte clarifyme the risk of using asynchronous commit http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:60447282988010

asynchronous commits should never be used in oltp.

async commits are most DEFINITELY not for transaction processing databases, they
basically mean "when you commit and you return from commit, the commit may or may NOT have happened yet, if the system fails after you return from commit but before the commit actually happens - you have to be prepared to REPLAY that transaction if necessary - something you can do in a batch load easily, but not so in a transactional system"

http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 26 2006 - 08:12:30 CDT