Re: Distributed Transactions and Two-Phase Commit

Rich,

One word of warning, two phase commits can, in the right conditions, lead to big time scalibility problems. Jonathan Lewis has written a paper describing the problem.
http://www.jlcomp.demon.co.uk/02_tpm.rtf. Hope this helps and sorry if you already had this info.

John
Mark D Powell wrote:
> With both versions 9.2 and 10g the DBA Administration Guide contains
> several chapters on distributed processing. The Oracle rdbms
> background process, reco, handles resolution of failed distributed
> transactions.
>
> Synonyms are not technically necessary for distributed transactions
> since you can just code the remote owner.object_name_at_link in your
SQL;
> however, providing synonyms for remote objects makes codeing
> distributed transactions easier for developers and end-users while
> providing location transparity.
>
> HTH -- Mark D Powell --
Received on Thu Mar 24 2005 - 10:45:44 CST