概述
Oracle数据库告警日志总是出现:Auto-tuning: Shutting down background process GTX1,而且归档告警比较奇怪的现象:alert.log出现这句问题就解决了。下面简单记录下~
查阅资料整理如下
(1)在RAC环境中,为支持global(XA)transaction设定了参数 global_txn_processes
(2)当系统global(XA)transaction很重的时候使用此参数global_txn_processes,一般不需要设定,这个提示是正常的
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 process