重庆思庄Oracle、Redhat认证学习论坛

标题: uto-tuning: Shutting Down Background Process GTX [ID 1481153.1] [打印本页]

作者: 郑全 时间: 2015-3-26 12:10
标题: uto-tuning: Shutting Down Background Process GTX [ID 1481153.1]

In this Document

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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)