ITPub博客

首页 > 数据库 > Oracle > RAC后台GTX进程

RAC后台GTX进程

原创 Oracle 作者:muxinqing 时间:2014-02-20 12:27:23 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29065182/viewspace-1084440/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-01-14

  • 博文量
    143
  • 访问量
    1202425