rac数据日志频繁关闭和启动gtx进程
Auto-tuning: Shutting down background process GTX6
Thu Feb 13 13:43:36 2014
Auto-tuning: Shutting down background process GTX5
Thu Feb 13 13:47:12 2014
Auto-tuning: Starting background process GTX5
Starting background process GTX5
Thu Feb 13 13:47:12 2014
GTX5 started with pid=37, OS id=12168
Thu Feb 13 13:47:17 2014
Auto-tuning: Starting background process GTX6
Starting background process GTX6
Thu Feb 13 13:47:17 2014
GTX6 started with pid=117, OS id=12170
Thu Feb 13 13:59:23 2014
Auto-tuning: Shutting down background process GTX6
Thu Feb 13 14:00:33 2014
Thread 1 advanced to log sequence 35984 (LGWR switch)
Current log# 2 seq# 35984 mem# 0: +ORADATA/crds3db/onlinelog/group2_1
Current log# 2 seq# 35984 mem# 1: +ORAARCH/crds3db/onlinelog/group2_2
Thu Feb 13 14:00:34 2014
Archived Log entry 135263 added for thread 1 sequence 35983 ID 0x9bc0299a dest 1:
Thu Feb 13 14:07:11 2014
Auto-tuning: Starting background process GTX6
Starting background process GTX6
Thu Feb 13 14:07:11 2014
GTX6 started with pid=86, OS id=13268
Auto-tuning: Starting background process GTX7
Starting background process GTX7
Thu Feb 13 14:07:16 2014
GTX7 started with pid=75, OS id=13270
Thu Feb 13 14:17:16 2014
Auto-tuning: Starting background process GTX8
Starting background process GTX8
Thu Feb 13 14:17:16 2014
GTX8 started with pid=101, OS id=13964
Thu Feb 13 14:27:37 2014
Auto-tuning: Shutting down background process GTX8
Thu Feb 13 14:37:58 2014
Auto-tuning: Shutting down background process GTX7
Thu Feb 13 14:48:24 2014
Auto-tuning: Shutting down background process GTX6
Thu Feb 13 14:58:17 2014
Thread 1 advanced to log sequence 35985 (LGWR switch)
Current log# 3 seq# 35985 mem# 0: +ORADATA/crds3db/onlinelog/group3_1
Current log# 3 seq# 35985 mem# 1: +ORAARCH/crds3db/onlinelog/group3_2
Thu Feb 13 14:58:18 2014
Archived Log entry 135267 added for thread 1 sequence 35984 ID 0x9bc0299a dest 1:
Thu Feb 13 14:58:41 2014
Auto-tuning: Shutting down background process GTX5
Thu Feb 13 15:11:57 2014
Auto-tuning: Shutting down background process GTX4
Thu Feb 13 15:24:07 2014
Auto-tuning: Shutting down background process GTX3
Thu Feb 13 15:27:11 2014
Auto-tuning: Starting background process GTX3
Starting background process GTX3
Thu Feb 13 15:27:11 2014
GTX3 started with pid=133, OS id=17845
Thu Feb 13 15:27:16 2014
Auto-tuning: Starting background process GTX4
Starting background process GTX4
Thu Feb 13 15:27:16 2014
GTX4 started with pid=114, OS id=17848
Thu Feb 13 15:27:22 2014
Auto-tuning: Starting background process GTX5
Starting background process GTX5
Thu Feb 13 15:27:22 2014
GTX5 started with pid=139, OS id=17850
Thu Feb 13 15:27:28 2014
Auto-tuning: Starting background process GTX6
Starting background process GTX6
Thu Feb 13 15:27:28 2014
GTX6 started with pid=150, OS id=17852
Thu Feb 13 15:29:42 2014
Thread 1 advanced to log sequence 35986 (LGWR switch)
Current log# 1 seq# 35986 mem# 0: +ORADATA/crds3db/onlinelog/group1_1
Current log# 1 seq# 35986 mem# 1: +ORAARCH/crds3db/onlinelog/group1_2
Thu Feb 13 15:29:42 2014
Archived Log entry 135271 added for thread 1 sequence 35985 ID 0x9bc0299a dest 1:
Thu Feb 13 15:37:13 2014
Auto-tuning: Starting background process GTX7
Starting background process GTX7
Thu Feb 13 15:37:14 2014
GTX7 started with pid=106, OS id=18381
Thu Feb 13 15:47:17 2014
Auto-tuning: Shutting down background process GTX7
Thu Feb 13 15:57:23 2014
Auto-tuning: Shutting down background process GTX6
[root@his1 trace]#
解決辦法：
一 忽略错误
这个后台进程是oracle自动调整不需要人工干预。
第二 这个GTX进程没有用上可以禁止掉，最好是不要禁止。
把设置参数为0就可以默认是为1
GLOBAL_TXN_PROCESSES = 0
