View Single Post

   
  #6 (permalink)  
Old 02-24-2008, 03:58 PM
HansF
 
Posts: n/a
Default Re: Asynchronous Commit in Oracle Database 10g R2

On Sat, 27 Aug 2005 14:30:26 -0700, fitzjarrell interested us by writing:

> Committing a transaction in a manner which
> may or may not get it to the redo logs is questionable and deserves
> CAREFUL thought and consideration before implementation.


AND yet .... when loading a warehouse, or any place in which all
transactions are repeatable, this might be perfectly acceptable. If the
system crashed during a bulk load, wipe and restart might be better than
recovery.

As you state eelsewhere in your reply, it requires careful consideration
and an awareness of what is right for the application.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Reply With Quote