
Oracle White Paper— XA and Oracle controlled Distributed Transactions
Introduction ....................................................................................... 2
Distributed Transactions Overview .................................................... 3
Oracle-Controlled Distributed Transactions ....................................... 4
XA Based Distributed Transactions ................................................... 6
The X/Open Distributed Transaction Processing Model ................. 6
JTA and JTS .................................................................................. 7
XA Transaction Concepts .............................................................. 8
XA and Point in Time data consistency across Resource Managers10
Using XA and Oracle-Controlled Distributed Transactions ............... 11
XA Timeouts and the Oracle Database ........................................ 11
Distributed Transactions and Database Locking .......................... 12
Distributed Transactions and Read Only Optimization ................. 14
Distributed Transactions and Redo .............................................. 14
Managing distributed transactions within the Oracle database..... 14
XA and Oracle Real Application Clusters (RAC) .......................... 15
Oracle Account Privileges ............................................................ 19
XA and Database Links ............................................................... 19
Oracle Real Application Testing and Distributed Transactions ..... 20
PL/SQL and XA ........................................................................... 20
Using XA and the Oracle Database from the Middle Tier ................. 21
XA and Oracle WebLogic Server / Fusion Middleware 11gR1 ..... 21
XA and Oracle 10gAs Application Server / Fusion Middleware 10g24
Typical Architecture and Design Problems with XA ......................... 25
Recovering Oracle databases...................................................... 25
Avoiding the XA Race Condition .................................................. 26
Conclusion ...................................................................................... 27
评论