scm0进程占用较高的cpu使用率

最新推荐文章于 2025-01-15 11:10:29 发布

好记忆不如烂笔头abc

最新推荐文章于 2025-01-15 11:10:29 发布

阅读量1.9k

点赞数

分类专栏： oracle12c

原文链接：https://www.anbob.com/archives/3357.html

版权

oracle12c 专栏收录该内容

81 篇文章

订阅专栏

本篇是12c版本中cpu high的第三种情况: scm0进程占用较高的cpu使用率。

[oracle@rac1 trace]$ top

top - 09:15:05 up 62 days, 7:36, 2 users, load average: 1.89, 1.94, 2.07
Tasks: 1119 total, 4 running, 1115 sleeping, 0 stopped, 0 zombie
Cpu(s): 5.9%us, 0.5%sy, 0.0%ni, 92.8%id, 0.7%wa, 0.0%hi, 0.0%si, 0.1%st
Mem: 132158648k total, 96802352k used, 35356296k free, 647160k buffers
Swap: 134217724k total, 0k used, 134217724k free, 32456040k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13440 oracle 20 0 40.4g 39m 32m R 99.8 0.0 16401:58 ora_scm0_testd1
20778 oracle 20 0 40.4g 50m 42m S 17.8 0.0 1:05.08 oracle_20778_te
27912 oracle 20 0 40.4g 51m 42m S 4.0 0.0 1:41.53 oracle_27912_te
23403 oracle 20 0 40.4g 50m 41m S 3.6 0.0 0:25.92 oracle_23403_te
26904 oracle 20 0 40.4g 28m 21m R 3.6 0.0 0:00.11 ora_m000_testd1
10402 root RT 0 1298m 170m 108m S 3.0 0.1 1780:15 osysmond.bin
23387 oracle 20 0 40.4g 49m 41m S 3.0 0.0 0:22.89 oracle_23387_te
10737 grid 20 0 2600m 85m 33m S 1.7 0.1 1527:50 oraagent.bin
13342 oracle -2 0 40.5g 50m 25m S 1.7 0.0 395:47.05 ora_lms0_testd1
13411 oracle 20 0 40.5g 96m 56m S 1.7 0.1 107:29.24 ora_mmon_testd1
13301 oracle -2 0 40.4g 23m 19m S 1.3 0.0 759:30.74 ora_vktm_testd1
13344 oracle -2 0 40.5g 50m 25m S 1.3 0.0 389:52.20 ora_lms1_testd1
18965 root 20 0 16188 1836 536 S 1.3 0.0 0:04.40 nmon
20146 oracle 20 0 40.4g 50m 42m S 1.3 0.0 1:19.71 oracle_20146_te
20240 oracle 20 0 40.4g 50m 42m S 1.3 0.0 1:08.55 oracle_20240_te
22195 oracle 20 0 40.4g 40m 33m S 1.3 0.0 0:11.21 oracle_22195_te
23390 oracle 20 0 40.4g 48m 41m S 1.3 0.0 0:23.08 oracle_23390_te
23397 oracle 20 0 40.4g 50m 42m S 1.3 0.0 0:22.97 oracle_23397_te
7559 grid RT 0 2879m 255m 117m S 1.0 0.2 802:34.16 ocssd.bin
10799 root 20 0 1141m 45m 27m S 1.0 0.0 797:49.77 orarootagent.bi
13334 oracle 20 0 40.5g 122m 25m S 1.0 0.1 1327:35 ora_dia0_testd1
21382 oracle 20 0 40.4g 53m 44m S 1.0 0.0 0:48.58 oracle_21382_te
23405 oracle 20 0 40.4g 50m 41m S 1.0 0.0 0:23.51 oracle_23405_te
26865 oracle 20 0 15836 2076 932 R 1.0 0.0 0:00.19 top
27736 oracle 20 0 40.4g 49m 41m S 1.0 0.0 0:29.33 oracle_27736_te
27757 oracle 20 0 40.4g 50m 42m S 1.0 0.0 1:51.50 oracle_27757_te
28171 oracle 20 0 40.4g 54m 44m R 1.0 0.0 1:33.78 oracle_28171_te
30463 oracle 20 0 40.4g 51m 42m S 1.0 0.0 1:54.26 oracle_30463_te
1396 oracle 20 0 40.4g 50m 41m S 0.7 0.0 0:16.72 oracle_1396_tes
3380 root 20 0 2396m 105m 42m S 0.7 0.1 358:25.31 ohasd.bin
10169 grid 20 0 1495m 27m 23m S 0.7 0.0 138:53.01 asm_lmhb_+asm1
10543 root RT -5 1155m 246m 108m S 0.7 0.2 740:14.55 ologgerd
13365 oracle 20 0 40.4g 31m 21m S 0.7 0.0 235:45.86 ora_cr00_testd1
22292 oracle 20 0 40.4g 45m 38m S 0.7 0.0 0:08.92 oracle_22292_te
22672 oracle 20 0 40.4g 50m 41m S 0.7 0.0 0:32.75 oracle_22672_te
23315 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:21.23 oracle_23315_te
23394 oracle 20 0 40.4g 49m 41m S 0.7 0.0 0:25.11 oracle_23394_te
23399 oracle 20 0 40.4g 50m 41m S 0.7 0.0 0:22.60 oracle_23399_te
25147 oracle 20 0 40.4g 48m 40m S 0.7 0.0 0:09.49 oracle_25147_te
2877 vservera 20 0 507m 15m 4264 S 0.3 0.0 216:17.89 vserver-guest-a
3599 root 20 0 317m 48m 9160 S 0.3 0.0 171:39.73 .tina_daemon.re
4815 root 20 0 228m 18m 2960 S 0.3 0.0 2:55.72 diagsnap.pl
6237 grid 20 0 1539m 55m 31m S 0.3 0.0 430:01.03 oraagent.bin
6270 grid 20 0 289m 16m 10m S 0.3 0.0 101:35.04 mdnsd.bin
6273 grid 20 0 708m 34m 16m S 0.3 0.0 317:32.45 evmd.bin
6364 root 20 0 1733m 198m 32m S 0.3 0.2 349:30.25 orarootagent.bi
6381 grid 20 0 715m 38m 16m S 0.3 0.0 305:57.07 gipcd.bin
6476 grid 20 0 297m 16m 11m S 0.3 0.0 100:27.45 evmlogger.bin
6591 oracle 20 0 40.4g 24m 21m S 0.3 0.0 74:12.25 ora_o021_testd1
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 13440 1 18 May16 ? 11-09:23:54 ora_scm0_testd1
oracle 27078 26728 0 09:17 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 17 09:19:16 2020

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter system set "_dlm_stats_collect" = 0 scope = spfile sid = '*';

System altered.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@rac1 trace]$ top

top - 09:19:36 up 62 days, 7:41, 2 users, load average: 1.34, 1.71, 1.94
Tasks: 1108 total, 2 running, 1106 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni, 0.8%id, 0.0%wa, 0.0%hi, 0.0%si, 99.2%st
Mem: 132158648k total, 96748524k used, 35410124k free, 647164k buffers
Swap: 134217724k total, 0k used, 134217724k free, 32457596k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13440 oracle 20 0 40.4g 39m 32m R 98.9 0.0 16406:27 ora_scm0_testd1
22701 oracle 20 0 40.4g 49m 41m S 5.7 0.0 0:31.24 oracle_22701_te
10419 root 20 0 3277m 131m 45m S 3.8 0.1 578:08.05 crsd.bin
20146 oracle 20 0 40.4g 50m 42m S 3.8 0.0 1:22.71 oracle_20146_te
20778 oracle 20 0 40.4g 51m 42m S 3.8 0.0 1:08.28 oracle_20778_te
23315 oracle 20 0 40.4g 50m 42m S 3.8 0.0 0:24.97 oracle_23315_te
27298 oracle 20 0 15832 1948 836 R 3.8 0.0 0:00.03 top
30463 oracle 20 0 40.4g 51m 42m S 3.8 0.0 1:57.35 oracle_30463_te
12152 grid 20 0 4686m 338m 27m S 1.9 0.3 226:19.30 java
13071 oracle 20 0 1276m 53m 30m S 1.9 0.0 157:10.17 oraagent.bin
13301 oracle -2 0 40.4g 23m 19m S 1.9 0.0 759:33.97 ora_vktm_testd1
13321 oracle 20 0 40.4g 35m 28m S 1.9 0.0 167:20.99 ora_dbrm_testd1
13334 oracle 20 0 40.5g 122m 25m S 1.9 0.1 1327:39 ora_dia0_testd1
13344 oracle -2 0 40.5g 50m 25m S 1.9 0.0 389:54.91 ora_lms1_testd1
13365 oracle 20 0 40.4g 31m 21m S 1.9 0.0 235:46.83 ora_cr00_testd1
13413 oracle 20 0 40.9g 545m 31m S 1.9 0.4 315:12.52 ora_mmnl_testd1
20240 oracle 20 0 40.4g 51m 42m S 1.9 0.0 1:11.29 oracle_20240_te
22703 oracle 20 0 40.4g 50m 41m S 1.9 0.0 0:34.48 oracle_22703_te
22715 oracle 20 0 40.4g 50m 42m S 1.9 0.0 0:31.11 oracle_22715_te
22719 oracle 20 0 40.4g 50m 42m S 1.9 0.0 0:31.82 oracle_22719_te
25141 oracle 20 0 40.4g 50m 41m S 1.9 0.0 0:11.04 oracle_25141_te
25143 oracle 20 0 40.4g 48m 41m S 1.9 0.0 0:12.53 oracle_25143_te
27912 oracle 20 0 40.4g 51m 42m S 1.9 0.0 1:45.05 oracle_27912_te
1 root 20 0 19356 1644 1304 S 0.0 0.0 9:58.40 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.01 kthreadd
3 root RT 0 0 0 0 S 0.0 0.0 0:23.00 migration/0
4 root 20 0 0 0 0 S 0.0 0.0 4:37.23 ksoftirqd/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
6 root RT 0 0 0 0 S 0.0 0.0 0:12.70 watchdog/0
7 root RT 0 0 0 0 S 0.0 0.0 0:27.66 migration/1
8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1
9 root 20 0 0 0 0 S 0.0 0.0 3:02.31 ksoftirqd/1
10 root RT 0 0 0 0 S 0.0 0.0 0:14.85 watchdog/1
11 root RT 0 0 0 0 S 0.0 0.0 0:50.12 migration/2
12 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/2
13 root 20 0 0 0 0 S 0.0 0.0 1:55.12 ksoftirqd/2
14 root RT 0 0 0 0 S 0.0 0.0 0:11.49 watchdog/2
15 root RT 0 0 0 0 S 0.0 0.0 0:55.17 migration/3
16 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/3
17 root 20 0 0 0 0 S 0.0 0.0 0:53.91 ksoftirqd/3
18 root RT 0 0 0 0 S 0.0 0.0 0:15.87 watchdog/3
19 root RT 0 0 0 0 S 0.0 0.0 0:45.97 migration/4
20 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/4
21 root 20 0 0 0 0 S 0.0 0.0 0:38.01 ksoftirqd/4
22 root RT 0 0 0 0 S 0.0 0.0 0:18.29 watchdog/4
23 root RT 0 0 0 0 S 0.0 0.0 0:48.05 migration/5
24 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/5
25 root 20 0 0 0 0 S 0.0 0.0 0:32.92 ksoftirqd/5
26 root RT 0 0 0 0 S 0.0 0.0 0:14.37 watchdog/5
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 13440 1 18 May16 ? 11-09:26:32 ora_scm0_testd1
oracle 27306 26728 0 09:19 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ kill -9 13440
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27322 26728 0 09:19 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27327 26728 0 09:19 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27331 26728 0 09:19 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27334 26728 0 09:19 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27340 26728 0 09:19 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ top

top - 09:20:08 up 62 days, 7:41, 2 users, load average: 0.99, 1.59, 1.90
Tasks: 1110 total, 1 running, 1108 sleeping, 0 stopped, 1 zombie
Cpu(s): 3.5%us, 0.5%sy, 0.0%ni, 95.9%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 132158648k total, 96753796k used, 35404852k free, 647164k buffers
Swap: 134217724k total, 0k used, 134217724k free, 32457840k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27372 oracle 20 0 40.4g 46m 38m S 48.2 0.0 0:01.46 ora_m000_testd1
6878 oracle 20 0 40.4g 51m 42m S 4.3 0.0 1:48.36 oracle_6878_tes
23315 oracle 20 0 40.4g 50m 42m S 3.6 0.0 0:25.33 oracle_23315_te
13342 oracle -2 0 40.5g 50m 25m S 2.0 0.0 395:50.68 ora_lms0_testd1
13344 oracle -2 0 40.5g 50m 25m S 2.0 0.0 389:55.24 ora_lms1_testd1
27755 oracle 20 0 40.4g 51m 42m S 2.0 0.0 1:49.15 oracle_27755_te
1396 oracle 20 0 40.4g 50m 41m S 1.7 0.0 0:18.25 oracle_1396_tes
10737 grid 20 0 2600m 85m 33m S 1.3 0.1 1527:58 oraagent.bin
13334 oracle 20 0 40.5g 122m 25m S 1.3 0.1 1327:40 ora_dia0_testd1
18860 oracle 20 0 40.4g 40m 34m S 1.3 0.0 0:21.85 oracle_18860_te
23317 oracle 20 0 40.4g 50m 41m S 1.3 0.0 0:27.22 oracle_23317_te
28019 oracle 20 0 40.4g 50m 42m S 1.3 0.0 0:24.21 oracle_28019_te
28021 oracle 20 0 40.4g 50m 41m S 1.3 0.0 0:20.54 oracle_28021_te
30589 oracle 20 0 40.4g 45m 38m S 1.3 0.0 0:26.09 oracle_30589_te
13301 oracle -2 0 40.4g 23m 19m S 1.0 0.0 759:34.27 ora_vktm_testd1
21386 oracle 20 0 40.4g 53m 44m S 1.0 0.0 0:53.25 oracle_21386_te
22672 oracle 20 0 40.4g 50m 41m S 1.0 0.0 0:35.71 oracle_22672_te
22674 oracle 20 0 40.4g 51m 42m S 1.0 0.0 0:29.43 oracle_22674_te
22701 oracle 20 0 40.4g 49m 41m S 1.0 0.0 0:31.53 oracle_22701_te
23387 oracle 20 0 40.4g 49m 41m S 1.0 0.0 0:26.91 oracle_23387_te
25143 oracle 20 0 40.4g 48m 41m S 1.0 0.0 0:12.73 oracle_25143_te
25145 oracle 20 0 40.4g 49m 41m S 1.0 0.0 0:10.62 oracle_25145_te
25147 oracle 20 0 40.4g 49m 40m S 1.0 0.0 0:12.03 oracle_25147_te
27341 oracle 20 0 15836 2044 932 R 1.0 0.0 0:00.13 top
30463 oracle 20 0 40.4g 51m 42m S 1.0 0.0 1:57.57 oracle_30463_te
6364 root 20 0 1733m 198m 32m S 0.7 0.2 349:32.08 orarootagent.bi
7559 grid RT 0 2879m 255m 117m S 0.7 0.2 802:40.33 ocssd.bin
10165 grid -2 0 1509m 61m 45m S 0.7 0.0 231:17.46 asm_lms0_+asm1
10402 root RT 0 1298m 170m 108m S 0.7 0.1 1780:23 osysmond.bin
10543 root RT -5 1155m 246m 108m S 0.7 0.2 740:18.93 ologgerd
10799 root 20 0 1141m 45m 27m S 0.7 0.0 797:52.77 orarootagent.bi
12024 grid 20 0 1446m 49m 35m S 0.7 0.0 176:25.22 mdb_cjq0_-mgmtd
20778 oracle 20 0 40.4g 50m 42m S 0.7 0.0 1:08.90 oracle_20778_te
21382 oracle 20 0 40.4g 53m 44m S 0.7 0.0 0:51.09 oracle_21382_te
22292 oracle 20 0 40.4g 46m 38m S 0.7 0.0 0:10.30 oracle_22292_te
22703 oracle 20 0 40.4g 50m 41m S 0.7 0.0 0:34.87 oracle_22703_te
22719 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:32.16 oracle_22719_te
23405 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:27.98 oracle_23405_te
25141 oracle 20 0 40.4g 50m 41m S 0.7 0.0 0:11.49 oracle_25141_te
28017 oracle 20 0 40.4g 49m 41m S 0.7 0.0 0:20.66 oracle_28017_te
28023 oracle 20 0 40.4g 51m 42m S 0.7 0.0 0:21.25 oracle_28023_te
28171 oracle 20 0 40.4g 54m 44m S 0.7 0.0 1:35.98 oracle_28171_te
28317 oracle 20 0 40.4g 54m 44m S 0.7 0.0 1:41.13 oracle_28317_te
29620 oracle 20 0 40.4g 48m 40m S 0.7 0.0 0:28.42 oracle_29620_te
30583 oracle 20 0 40.4g 54m 44m S 0.7 0.0 1:37.65 oracle_30583_te
1 root 20 0 19356 1644 1304 S 0.3 0.0 9:58.41 init
141 root 20 0 0 0 0 S 0.3 0.0 9:20.26 events/26
204 root 20 0 0 0 0 S 0.3 0.0 6:01.85 kblockd/26
3380 root 20 0 2396m 105m 42m S 0.3 0.1 358:27.16 ohasd.bin
[oracle@rac1 trace]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.CRS.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DATA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.proxy_advm
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.124.104 192.
168.0.59,STABLE
ora.asm
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.testd.db
1 ONLINE ONLINE rac1 Open,HOME=/oracle/ap
p/oracle/product/12.
2.0/dbhome_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/oracle/ap
p/oracle/product/12.
2.0/dbhome_1,STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
[oracle@rac1 trace]$ sar 1 10
Linux 2.6.32-431.56.1.el6.x86_64 (rac1) 07/17/2020 _x86_64_ (28 CPU)

09:20:37 AM CPU %user %nice %system %iowait %steal %idle
09:20:38 AM all 1.29 0.00 0.21 0.86 0.04 97.60
09:20:39 AM all 1.61 0.00 0.25 0.04 0.11 97.99
09:20:40 AM all 1.65 0.00 0.39 0.11 0.04 97.82
09:20:41 AM all 3.99 0.00 0.57 0.04 0.07 95.33
09:20:42 AM all 4.04 0.00 0.72 0.00 0.07 95.17
09:20:43 AM all 3.44 0.00 0.65 0.11 0.11 95.69
09:20:44 AM all 4.88 0.00 1.26 1.69 0.04 92.14
09:20:45 AM all 4.05 0.00 1.29 3.01 0.11 91.53
09:20:46 AM all 3.91 0.00 1.00 0.68 0.21 94.20
09:20:47 AM all 4.08 0.00 1.29 0.21 0.29 94.12
Average: all 3.29 0.00 0.76 0.67 0.11 95.16
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27410 1 0 09:20 ? 00:00:00 ora_scm0_testd1
oracle 27504 26728 0 09:21 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ top

top - 09:21:36 up 62 days, 7:43, 2 users, load average: 0.74, 1.39, 1.80
Tasks: 1114 total, 3 running, 1110 sleeping, 0 stopped, 1 zombie
Cpu(s): 3.9%us, 1.1%sy, 0.0%ni, 94.8%id, 0.1%wa, 0.0%hi, 0.0%si, 0.1%st
Mem: 132158648k total, 96766076k used, 35392572k free, 647164k buffers
Swap: 134217724k total, 0k used, 134217724k free, 32458316k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27546 grid 20 0 1461m 39m 27m R 22.8 0.0 0:00.69 mdb_j000_-mgmtd
123 root 20 0 0 0 0 S 12.9 0.0 5:33.76 events/8
30463 oracle 20 0 40.4g 51m 42m S 12.5 0.0 1:58.72 oracle_30463_te
10402 root RT 0 1298m 170m 108m S 11.9 0.1 1780:26 osysmond.bin
23317 oracle 20 0 40.4g 50m 41m S 8.9 0.0 0:28.52 oracle_23317_te
2196 root 20 0 10952 696 424 S 8.6 0.0 18:54.86 irqbalance
23405 oracle 20 0 40.4g 50m 42m S 7.9 0.0 0:29.31 oracle_23405_te
30583 oracle 20 0 40.4g 54m 44m S 4.3 0.0 1:38.93 oracle_30583_te
22715 oracle 20 0 40.4g 50m 42m S 3.6 0.0 0:32.29 oracle_22715_te
23315 oracle 20 0 40.4g 50m 42m S 3.6 0.0 0:26.42 oracle_23315_te
13334 oracle 20 0 40.5g 122m 25m S 3.3 0.1 1327:41 ora_dia0_testd1
23399 oracle 20 0 40.4g 50m 41m R 3.3 0.0 0:27.54 oracle_23399_te
12534 grid 20 0 1509m 45m 42m S 2.3 0.0 2:45.99 oracle_12534_+a
7559 grid RT 0 2879m 255m 117m S 2.0 0.2 802:41.39 ocssd.bin
10737 grid 20 0 2600m 85m 33m S 2.0 0.1 1528:00 oraagent.bin
10419 root 20 0 3277m 131m 45m S 1.6 0.1 578:10.04 crsd.bin
10543 root RT -5 1155m 246m 108m S 1.6 0.2 740:20.04 ologgerd
20240 oracle 20 0 40.4g 51m 42m S 1.6 0.0 1:12.80 oracle_20240_te
22703 oracle 20 0 40.4g 50m 41m S 1.6 0.0 0:35.73 oracle_22703_te
23390 oracle 20 0 40.4g 49m 41m S 1.6 0.0 0:28.20 oracle_23390_te
1396 oracle 20 0 40.4g 50m 41m S 1.3 0.0 0:18.43 oracle_1396_tes
6878 oracle 20 0 40.4g 51m 42m S 1.3 0.0 1:49.14 oracle_6878_tes
10799 root 20 0 1141m 45m 27m S 1.3 0.0 797:53.63 orarootagent.bi
22672 oracle 20 0 40.4g 50m 41m S 1.3 0.0 0:36.42 oracle_22672_te
27476 oracle 20 0 98.6m 796 684 S 1.3 0.0 0:00.30 sadc
27755 oracle 20 0 40.4g 51m 42m S 1.3 0.0 1:49.92 oracle_27755_te
13301 oracle -2 0 40.4g 23m 19m S 1.0 0.0 759:35.23 ora_vktm_testd1
13342 oracle -2 0 40.5g 50m 25m S 1.0 0.0 395:52.25 ora_lms0_testd1
20778 oracle 20 0 40.4g 50m 42m S 1.0 0.0 1:09.63 oracle_20778_te
23387 oracle 20 0 40.4g 50m 41m S 1.0 0.0 0:27.55 oracle_23387_te
23407 oracle 20 0 40.4g 49m 41m S 1.0 0.0 0:27.36 oracle_23407_te
27506 oracle 20 0 15836 2076 932 R 1.0 0.0 0:00.18 top
6237 grid 20 0 1539m 55m 31m S 0.7 0.0 430:03.06 oraagent.bin
6381 grid 20 0 715m 38m 16m S 0.7 0.0 305:58.66 gipcd.bin
10163 grid 20 0 1510m 54m 39m S 0.7 0.0 165:39.30 asm_lmd0_+asm1
13344 oracle -2 0 40.5g 50m 25m S 0.7 0.0 389:56.12 ora_lms1_testd1
13365 oracle 20 0 40.4g 31m 21m S 0.7 0.0 235:47.37 ora_cr00_testd1
18757 grid 20 0 1496m 35m 30m S 0.7 0.0 3:51.99 asm_ppa7_+asm1
22674 oracle 20 0 40.4g 51m 42m S 0.7 0.0 0:30.53 oracle_22674_te
22719 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:33.82 oracle_22719_te
23313 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:25.59 oracle_23313_te
24813 oracle 20 0 40.4g 37m 32m S 0.7 0.0 0:06.60 oracle_24813_te
25143 oracle 20 0 40.4g 48m 41m S 0.7 0.0 0:13.10 oracle_25143_te
27753 oracle 20 0 40.4g 51m 42m S 0.7 0.0 1:51.39 oracle_27753_te
27761 oracle 20 0 40.4g 51m 42m S 0.7 0.0 1:50.30 oracle_27761_te
27912 oracle 20 0 40.4g 51m 42m S 0.7 0.0 1:46.60 oracle_27912_te
28023 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:21.39 oracle_28023_te
13 root 20 0 0 0 0 S 0.3 0.0 1:55.13 ksoftirqd/2
124 root 20 0 0 0 0 S 0.3 0.0 5:32.38 events/9
[oracle@rac1 trace]$ ps -ef|grep scm
oracle 27410 1 0 09:20 ? 00:00:00 ora_scm0_testd1
oracle 27557 26728 0 09:21 pts/0 00:00:00 grep scm
[oracle@rac1 trace]$ top

top - 09:21:57 up 62 days, 7:43, 2 users, load average: 0.59, 1.31, 1.76
Tasks: 1117 total, 3 running, 1114 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.9%us, 0.5%sy, 0.0%ni, 97.0%id, 0.5%wa, 0.0%hi, 0.0%si, 0.2%st
Mem: 132158648k total, 96782040k used, 35376608k free, 647164k buffers
Swap: 134217724k total, 0k used, 134217724k free, 32458420k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23399 oracle 20 0 40.4g 50m 41m S 26.7 0.0 0:28.56 oracle_23399_te
25143 oracle 20 0 40.4g 48m 41m S 4.0 0.0 0:13.27 oracle_25143_te
23403 oracle 20 0 40.4g 50m 41m S 3.6 0.0 0:30.48 oracle_23403_te
10402 root RT 0 1298m 170m 108m S 3.3 0.1 1780:26 osysmond.bin
21386 oracle 20 0 40.4g 53m 44m S 3.3 0.0 0:53.89 oracle_21386_te
10737 grid 20 0 2600m 85m 33m S 1.7 0.1 1528:01 oraagent.bin
20240 oracle 20 0 40.4g 50m 42m S 1.3 0.0 1:13.09 oracle_20240_te
22674 oracle 20 0 40.4g 51m 42m S 1.3 0.0 0:30.76 oracle_22674_te
23313 oracle 20 0 40.4g 50m 42m S 1.3 0.0 0:25.70 oracle_23313_te
23394 oracle 20 0 40.4g 49m 41m S 1.3 0.0 0:29.94 oracle_23394_te
10799 root 20 0 1141m 45m 27m S 1.0 0.0 797:53.82 orarootagent.bi
13301 oracle -2 0 40.4g 23m 19m S 1.0 0.0 759:35.41 ora_vktm_testd1
13334 oracle 20 0 40.5g 122m 25m S 1.0 0.1 1327:41 ora_dia0_testd1
23405 oracle 20 0 40.4g 50m 42m S 1.0 0.0 0:29.66 oracle_23405_te
25141 oracle 20 0 40.4g 51m 41m S 1.0 0.0 0:12.13 oracle_25141_te
25147 oracle 20 0 40.4g 50m 41m S 1.0 0.0 0:12.78 oracle_25147_te
25149 oracle 20 0 40.4g 49m 41m S 1.0 0.0 0:12.51 oracle_25149_te
27578 oracle 20 0 15836 2080 932 R 1.0 0.0 0:00.07 top
27912 oracle 20 0 40.4g 51m 42m S 1.0 0.0 1:46.70 oracle_27912_te
6273 grid 20 0 708m 34m 16m S 0.7 0.0 317:34.78 evmd.bin
6878 oracle 20 0 40.4g 51m 42m S 0.7 0.0 1:49.25 oracle_6878_tes
7559 grid RT 0 2879m 255m 117m S 0.7 0.2 802:42.13 ocssd.bin
10543 root RT -5 1155m 246m 108m S 0.7 0.2 740:20.20 ologgerd
13342 oracle -2 0 40.5g 50m 25m S 0.7 0.0 395:52.40 ora_lms0_testd1
13344 oracle -2 0 40.5g 50m 25m S 0.7 0.0 389:56.30 ora_lms1_testd1
18860 oracle 20 0 40.4g 40m 34m S 0.7 0.0 0:22.29 oracle_18860_te
22701 oracle 20 0 40.4g 49m 41m S 0.7 0.0 0:32.25 oracle_22701_te
22715 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:32.41 oracle_22715_te
22719 oracle 20 0 40.4g 50m 42m S 0.7 0.0 0:34.53 oracle_22719_te
23317 oracle 20 0 40.4g 50m 41m S 0.7 0.0 0:28.73 oracle_23317_te
23387 oracle 20 0 40.4g 49m 41m S 0.7 0.0 0:27.97 oracle_23387_te
27476 oracle 20 0 98.6m 796 684 S 0.7 0.0 0:00.47 sadc
30463 oracle 20 0 40.4g 51m 42m S 0.7 0.0 1:58.94 oracle_30463_te
120 root 20 0 0 0 0 S 0.3 0.0 5:16.16 events/5
181 root 20 0 0 0 0 S 0.3 0.0 4:25.40 kblockd/3
2877 vservera 20 0 507m 15m 4264 S 0.3 0.0 216:19.27 vserver-guest-a
3380 root 20 0 2396m 105m 42m S 0.3 0.1 358:27.62 ohasd.bin
3599 root 20 0 317m 48m 9160 S 0.3 0.0 171:40.87 .tina_daemon.re
4815 root 20 0 228m 18m 2960 S 0.3 0.0 2:56.69 diagsnap.pl
6237 grid 20 0 1539m 55m 31m S 0.3 0.0 430:03.17 oraagent.bin
6381 grid 20 0 715m 38m 16m S 0.3 0.0 305:58.73 gipcd.bin
6614 root RT 0 1091m 149m 109m S 0.3 0.1 162:16.23 cssdmonitor
7513 root RT 0 1092m 149m 109m S 0.3 0.1 169:22.50 cssdagent
8694 root 20 0 834m 32m 14m S 0.3 0.0 360:45.48 octssd.bin
10158 grid 20 0 1520m 71m 45m S 0.3 0.1 434:48.23 asm_dia0_+asm1
10161 grid 20 0 1510m 60m 45m R 0.3 0.0 108:29.35 asm_lmon_+asm1
10165 grid -2 0 1509m 61m 45m S 0.3 0.0 231:18.00 asm_lms0_+asm1
10169 grid 20 0 1495m 27m 23m S 0.3 0.0 138:53.67 asm_lmhb_+asm1
10193 grid 20 0 1494m 24m 20m S 0.3 0.0 192:32.05 asm_imr0_+asm1
[oracle@rac1 trace]$

前两篇如下

Oracle12c R2注意事项：大量crsctl.bin进程cpu使用率高，等待crs call completion

Oracle12c R2注意事项：多个”/usr/bin/ssh -o StrictHostKeyChecking… /sbin/ifconfig -a”进程导到CPU使用高

(Distributed Lock Management )DLM Statistics Collection and Management从属（SCM0）后台进程负责收集和管理全局入队服务（GES）和全局缓存服务（GCS）的统计信息。如果在数据库中启用了DLM统计信息收集此进程（scm0）才会存在，但是官方描述在12.2版本，默认即使收集了DLM statistics在12.2版本中的use these stats service based affinity and cache warmup功能也是禁用的，只是为了后续版本准备，所以在禁用该进程不会影响12C r2版本。

原因是bug 24590018 – RAC PERF: SCM0 PROCESS USING 100% CPU, FG’S USING ~80% SYS CPU POSTING SCM0

要解决此问题，必须停用DLM统计信息收集，或者手动kill scm0进程并此进程会自动启动。

禁用DLM统计信息收集方法:

SQL> alter system set "_dlm_stats_collect" = 0 scope = spfile sid = '*';

注意_dlm_stats_collect参数更改需要重新启动数据库。

另一种是确定相应scm0进程的进程id，并用kill -9关闭它。关闭后，此进程将自动重启。

[root@anbob01 ~]# ps -ef|grep scm
oracle 11762 1 0 May22 ? 00:02:28 ora_scm0_ANBOB1

[root@anbob01 ~]# kill -9 11762

建议在安装12C R2时就配置如下参数：

alter system set “_dlm_stats_collect” = 0 scope = spfile sid = ‘*’;

https://blog.csdn.net/weixin_34389926/article/details/93460866