Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | Integer |
Default value | 1 |
Modifiable | ALTER SYSTEM |
Range of values | 0 to 20 |
Basic | No |
Oracle RAC | Multiple instances can have different values. |
GLOBAL_TXN_PROCESSES
specifies the initial number of GTXn background processes (GTX0, ... GTX9 and GTXa, ... GTXj) per instance to support global (XA) transactions in an Oracle RAC environment.
If you want to disable the GTXn background processes, then you must set GLOBAL_TXN_PROCESSES
to 0
in your parameter file. Setting this parameter to 0
will disable the XA support on an Oracle RAC database. Error ORA-55712
will be returned if you try to run XA transactions on an Oracle RAC database with this parameter set to zer0
. You can change the setting to a nonzero value at runtime to turn on the support for XA.
GLOBAL_TXN_PROCESSES
is useful for systems that process global (XA) transactions heavily. You do not need to specify a value for this parameter since Oracle Database automatically determines the number of processes and autotunes them, as necessary. GTXn background processes are only seen in an Oracle RAC environment.
See Also:
Oracle Database Advanced Application Developer's Guide for more information about this parameter and Oracle XA