GoldenGate Director 疯狂发出 ggsci 命令致主数据库CPU使用率居高不下
今天早上 8 点多钟,发现主数据库 CPU 持续居高不下,一直维持在 90% 左右,而这个点数据库应该闲的蛋疼
topas 发现耗掉 CPU 的全是 ggsci 进程。
Topas Monitor for host: bjsczjdbzsj01 EVENTS/QUEUES FILE/TTY
Tue Mar 19 09:00:01 2013 Interval: 2 Cswitch 56687 Readch 197.5M
Syscall 120.7K Writech 4112.5K
CPU User% Kern% Wait% Idle% Physc Entc Reads 32220 Rawin 0
ALL 82.2 5.6 1.2 11.0 11.63 116.3 Writes 13182 Ttyout 600
Forks 23 Igets 0
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 23 Namei 13892
Total 741.4 786.6 444.0 563.1 178.4 Runqueue 33.5 Dirblk 0
Waitqueue 1.0
Disk Busy% KBPS TPS KB-Read KB-Writ MEMORY
Total 100.0 48.4K 10.1K 47.4K 938.6 PAGING Real,MB 81920
Faults 30321 % Comp 94
FileSystem KBPS TPS KB-Read KB-Writ Steals 15501 % Noncomp 5
Total 187.4K 17.9K 187.3K 121.5 PgspIn 0 % Client 5
PgspOut 0
Name PID CPU% PgSp Owner PageIn 9507 PAGING SPACE
ggsci 46006566 8.6 15.7 oracle PageOut 47 Size,MB 16384
ocssd.bi 8388624 4.3 133.5 grid Sios 9550 % Used 24
oracle 11403492 4.3 42.5 oracle % Free 76
ggsci 15925646 4.3 15.7 oracle NFS (calls/sec)
ggsci 31392128 4.3 15.7 oracle SerV2 0 WPAR Activ 0
ggsci 6095204 4.3 15.7 oracle CliV2 0 WPAR Total 0
ggsci 23134254 4.3 15.7 oracle SerV3 0 Press: &qu