- 论坛徽章:
- 0
|
分析初步结论
通过进一步观察和分析,
6号日志:
oracle@main-db1$cat top0706.log |grep load |sort +6nr |more
last pid: 8008; load averages: 7.84, 2.89, 1.57 02:59:02
last pid: 8008; load averages: 7.54, 2.88, 1.57 02:59:07
last pid: 8008; load averages: 7.08, 2.86, 1.57 02:59:10
last pid: 8008; load averages: 6.75, 2.84, 1.56 02:59:13
last pid: 8008; load averages: 6.44, 2.81, 1.56 02:59:16
last pid: 8008; load averages: 6.14, 2.79, 1.55 02:59:19
last pid: 8019; load averages: 5.89, 2.77, 1.55 02:59:22
last pid: 8005; load averages: 7.77, 2.76, 1.51 02:58:59
last pid: 8019; load averages: 5.63, 2.75, 1.55 02:59:25
last pid: 8019; load averages: 5.38, 2.73, 1.55 02:59:28
last pid: 8019; load averages: 5.21, 2.72, 1.55 02:59:31
7号日志:
oracle@main-db1$cat top0707.log |grep load |sort +6nr |more
last pid: 28600; load averages: 7.18, 2.29, 1.23 02:58:54
last pid: 28600; load averages: 6.80, 2.28, 1.23 02:58:57
last pid: 28600; load averages: 6.48, 2.26, 1.23 02:59:00
last pid: 28600; load averages: 6.23, 2.25, 1.23 02:59:03
last pid: 28600; load averages: 5.95, 2.23, 1.22 02:59:06
last pid: 28600; load averages: 5.67, 2.21, 1.22 02:59:09
last pid: 28600; load averages: 5.41, 2.20, 1.22 02:59:12
last pid: 28600; load averages: 5.18, 2.18, 1.21 02:59:15
last pid: 28600; load averages: 4.93, 2.16, 1.21 02:59:18
last pid: 28612; load averages: 4.70, 2.14, 1.21 02:59:21
8号日志:
oracle@main-db1$cat top0708.log |grep load |sort +6nr |more
last pid: 19395; load averages: 8.15, 3.26, 1.81 02:58:47
last pid: 19395; load averages: 7.82, 3.24, 1.81 02:58:50
last pid: 19395; load averages: 7.55, 3.23, 1.81 02:58:53
last pid: 19395; load averages: 7.31, 3.22, 1.81 02:58:56
last pid: 19395; load averages: 7.00, 3.20, 1.81 02:58:59
last pid: 19395; load averages: 6.47, 3.18, 1.81 02:59:06
last pid: 19395; load averages: 6.71, 3.18, 1.80 02:59:03
last pid: 19395; load averages: 6.29, 3.17, 1.82 02:59:09
都是集中在某个特定时间点.
观察相应时间点详细的Top 信息,发现都有几个Oracle的进程在跑. 虽然这几个进程本身占用资源很少,但是正好这个时间点系统的SYS Load很高.
结合Oracle的日志(database event trigger, log the connect of oracle user,time,spid etc),发现都是perfstat用户的logon,怀疑可能和这个有关系.
8号下午disable了这个相应的Cron, 9号没有发现有大的Load出现的情况.
oracle@main-db1$cat top0709.log |grep load |sort +6nr |more
last pid: 9863; load averages: 1.28, 1.13, 0.93 02:07:18
last pid: 9854; load averages: 1.36, 1.12, 0.91 02:06:20
last pid: 9857; load averages: 1.25, 1.12, 0.93 02:07:12
last pid: 9857; load averages: 1.26, 1.12, 0.92 02:07:09
last pid: 9868; load averages: 1.18, 1.12, 0.93 02:07:46
last pid: 9868; load averages: 1.19, 1.12, 0.93 02:07:43
last pid: 9868; load averages: 1.19, 1.12, 0.94 02:08:07
last pid: 9868; load averages: 1.20, 1.12, 0.94 02:08:04
初步归结为记录数据库和主机性能的cron造成的影响.疑惑是这几个进程本身占用的资源很少, 即使占资源也不应该是SYS态的资源占用.
疑惑是为什么会有SYS态的CPU占用. |
|