Saturday, July 30, 2011

Auto-tuning: Shutting down background process GTX3

In RAC Database DBA may found Auto-tuning: Shutting down background process GTXn in alert log file, which is non corruptive.

GTXn

Global Transaction Process
Provides transparent support for XA global transactions in an Oracle RAC environment

These processes help maintain the global information about XA global transactions throughout the cluster. Also, the processes help perform two-phase commit for global transactions anywhere in the cluster so that an Oracle RAC database behaves as a single system to the externally coordinated distributed transactions.The GLOBAL_TXN_PROCESSES initialization parameter specifies the number of GTXn processes, where n is 0-9 or a-j. The database automatically tunes the number of these processes based on the workload of XA global transactions. You can disable these processes by setting the parameter to 0. If you try to run XA global transactions with these process disabled, an error is returned.

No comments:

Post a Comment