RAC後臺GTX程式
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [zt] Oracle RAC 後臺程式Oracle
- 關於Oracle RAC後臺程式Oracle
- Oracle RAC後臺程式介紹Oracle
- rac讀書札記---後臺程式
- RAC資料庫後臺程式介紹資料庫
- RAC例項中附加的後臺程式
- rac後臺程式說明及一些概念
- ORACLE後臺程式Oracle
- oracle 後臺程式Oracle
- Clusterware 後臺程式
- 將程式在後臺執行和殺掉後臺的程式
- WINDOWS ORACLE 後臺程式WindowsOracle
- Oracle後臺程式列表Oracle
- 後臺程式介紹
- Dataguard(Standby) 後臺程式
- Oracle 後臺程式 說明Oracle
- Oracle後臺程式詳述Oracle
- 幾個必要後臺程式
- linux程式前臺-後臺執行Linux
- IOS 後臺掛起程式 當程式到後臺後,繼續完成Long Running Task 任務iOS
- jenkins後臺程式執行Jenkins
- 編寫python後臺程式Python
- Oracle VKRM 後臺程式介紹Oracle
- 修改dbwr後臺程式數量
- ORACLE 10G 後臺程式Oracle 10g
- oracle架構之後臺程式Oracle架構
- solidDB 後臺啟動程式Solid
- Linux:後臺執行程式Linux行程
- linux殺死後臺程式Linux
- 後臺執行以及保持程式在後臺長時間執行
- Oracle程式結構及後臺程式簡介Oracle
- 微信小程式 部署(後臺是springboot專案 前後臺分流)微信小程式Spring Boot
- vue後臺管理系統程式碼Vue
- LaraCMS 後臺管理系統 - 小程式ACM
- Ubuntu16.04 -- 後臺程式NohupUbuntu
- 分享C++寫後臺程式碼C++
- 從零搭建微信小程式後臺微信小程式
- 實驗,暫停oracle後臺程式Oracle