6.4.2.2 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 to true in the tmm.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 the oracle.tmm.promotable property as false, every transaction starts as a global transaction by default and it is associated with a GTRID. A local transaction is not initiated.