Important note about asynchronous commit

  • From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
  • To: "Oracle-L Freelists" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Tue, 26 Sep 2006 09:12:30 -0400

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

Tom Kyte clarifyme the risk of using asynchronous commit

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"

-- ----------------------------------------

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

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

Other related posts: