Re: Asynchronous Commit in Oracle Database 10g R2

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:dfbma4$hg1$1_at_nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...

> An example where this is very bad -
> loop
> read value from row in database
> mark row as processed
> use extproc to transfer value to Swiss bank account
> commit;
> end loop;
>
> If the database crashes, you could be in a position where
> the extproc has sent the funds, but the committed change
> was not written into the redo log FILE. When the database
> restarts, you have repeat a couple of transfers.
>
> As soon as you are able to get a message out of the black
> box that is the database (in this case pl/sql) call, you have
> the ability to detect a commit that is not recoverable.

Thanks for your comments.

>
>
> --
> Regards
>
> Jonathan Lewis
Received on Sat Sep 03 2005 - 08:19:37 CDT