RAC後臺GTX程式

路途中的人2012發表於2016-12-21

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/29067253/viewspace-2131099/,如需轉載,請註明出處,否則將追究法律責任。

相關文章