CNDBA社区
Oracle RAC alert log 中 Shutting down background process GTX 说明
作者：
dave
在Oracle 11g的RAC alert log 日志中会看到如下信息：
Sun Jul 20 03:25:36 2025
Auto-tuning: Shutting down background process GTX5
Sun Jul 20 03:35:37 2025
Auto-tuning: Shutting down background process GTX4
Sun Jul 20 03:45:38 2025
Auto-tuning: Shutting down background process GTX3
Sun Jul 20 03:55:43 2025
Auto-tuning: Shutting down background process GTX2
MOS 对该信息有说明：
Auto-tuning: Shutting Down Background Process GTX (Doc ID 1481153.1)
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.
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.
在Oracle RAC中，Global (XA) Transactions支持分布式事务的处理，其实现依赖于RAC架构的协同工作能力。Global Transactions（全局事务）是基于XA协议的分布式事务标准，用于跨多个数据库实例或资源管理器（如Oracle RAC节点）协调事务的一致性。
所以这个告警是个正常的记录，可以忽略。Oracle自动创建GTX进程管理XA事务的分支协调和状态维护。Oracle自动根据XA事务负载动态调整GTX进程数量。若无XA事务需求，可通过参数 GLOBAL_TXN_PROCESSES=0 禁用。
版权声明：本文为博主原创文章，未经博主允许不得转载。
