uto-tuning: Shutting Down Background Process GTX [ID 1481153.1]

郑全

In this Document

Symptoms

Changes

Cause

Solution

---

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
Auto-tuning: Starting background process GTX1
Starting background process GTX1

and

Auto-tuning: Shutting down background process GTXi Like messages in alert log

Symptoms

 Auto-tuning: Starting background process GTX1..
Starting background process GTX1..

and

Auto-tuning: Shutting down background process GTXi Like messages in alert log in RAC database

Changes

This message will seen only in  RAC enviornment

Cause

 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.

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.

GTX (Global Transaction Process) as per definition maintains the global information about XA global transactions throughout the cluster.

Solution

 1. Its normal for the database to automatically tune the number of these processes based on the workload of XA global transactions.If any application which using XA transaction and connecting to oracle RAC database, is it required.This a normal behavior. and you do not have to worry about this error messages. Ignore Them

2.  If you are sure that you are not using XA and want to stop these messages.You can 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.

Please refer -

 

Oracle? Database Reference
11g Release 2 (11.2)
Part Number E10820-02 -> GLOBAL_TXN_PROCESSES

 

Overview of XA Transactions and DTP Services
http://docs.oracle.com/cd/E11882_01/rac.112/e16795/hafeats.htm#RACAD8287

Oracle Database Reference 11g Release 2 (11.2)
http://docs.oracle.com/cd/E11882_01/server.112/e25513/bgprocesses.htm#REFRN104
GTXn Global Transaction Process

Oracle Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)
http://docs.oracle.com/cd/E11882_01/rac.112/e16795/hafeats.htm#RACAD7147
Services and Distributed Transaction Processing in Oracle RAC