7.6.2.3 Enable Transaction Promotion
By default, all transactions are associated with a global transaction ID (GTRID) and handled as a global transaction. To experience better performance, enable transaction promotion to manage certain transactions.
Note:
This feature is available only in Oracle Database.To enable transaction promotion:
- Set the
oracle.tmm.promotable
property totrue
in thetmm.properties
file for the initiator service. When you enable transaction promotion, the transactions which can be handled locally are managed without involving the coordinator.The default value is
false
. If you set the value of theoracle.tmm.promotable
property asfalse
, every transaction starts as a global transaction by default and it is associated with a GTRID. A local transaction is not initiated.
Parent topic: About Global and Local Transactions