一个db占用太多cpu,该怎样解决?

os:solaris 9          oracle 10.2.0.3.0

开发环境,这个机器上有几个db,topdev 是其中一个,几乎用光所用cup资源.
请高手给指点一下,该怎样解决?

11521 oratop 641M  484M run    22 0 317:46:22 7.9% oracle/1
13263 oratop 641M  483M run    41 0 320:46:18 7.7% oracle/1
11947 oratop 645M  488M run    32 0 310:59:14 7.6% oracle/1
  7604 oratop 641M  484M run    33 0 307:51:55 7.5% oracle/1
10570 oratop 641M  484M run    32 0 305:08:33 7.4% oracle/1
11205 oratop 641M  484M run    42 0 312:40:19 7.4% oracle/1
10173 oratop 641M  487M run    33 0 321:12:59 7.4% oracle/1
12237 oratop 641M  487M cpu1 32 0 314:45:31 7.3% oracle/1
11257 oratop 641M  484M run    32 0 307:36:43 7.1% oracle/1
10448 oratop 641M  485M run    33 0 305:51:52 7.1% oracle/1
11289 oratop 645M  490M run    42 0 305:01:54 6.9% oracle/1
11685 oratop 641M  484M run    42 0 305:34:14 6.9% oracle/1
16223 oracle 444M  357M run    29 0  49:05:42 1.3% oracle/1
16271 oracle 444M  356M sleep 59 0  49:36:17 1.0% oracle/1
16269 oracle 444M  354M sleep 59 0  49:30:20 0.9% oracle/1
16261 oracle 444M  355M sleep 59 0  49:31:21 0.9% oracle/1
16253 oracle 444M  357M sleep 59 0  49:19:55 0.9% oracle/1
16241 oracle 444M  356M sleep 59 0  49:06:43 0.8% oracle/1

  oratop 11289    1  7 Mar 26 ?    18302:05 oracletopdev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oratop  1751 16068  0 16:38:24 pts/1 0:00 egrep 11521|13263|11947|7604|10570|11205|10173|12237|11257|10448|11289|11685
  oratop 11685    1  7 Mar 26 ?    18334:25 oracletopdev (LOCAL=NO)
  oratop 11205    1  7 Mar 26 ?    18760:29 oracletopdev (LOCAL=NO)
  oratop 10173    1  7 Mar 26 ?    19273:09 oracletopdev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oratop 12237    1  7 Mar 26 ?    18885:41 oracletopdev (LOCAL=NO)
  oratop 11257    1  6 Mar 26 ?    18456:53 oracletopdev (LOCAL=NO)
  oratop 13263    1  7 Mar 26 ?    19246:28 oracletopdev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oratop 10448    1  7 Mar 26 ?    18352:02 oracletopdev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oratop 10570    1  8 Mar 26 ?    18308:44 oracletopdev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oratop  7604    1  7 Mar 26 ?    18472:06 oracletopdev (LOCAL=NO)
  oratop 11947    1  7 Mar 26 ?    18659:24 oracletopdev (LOCAL=NO)
  oratop 11521    1  7 Mar 26 ?    19066:32 oracletopdev (LOCAL=NO)

应该第一时间查看这些session在做什么事情，根据v$process和v$session的mapping关系找出对应的sid，找出对应的sql语句

我查到了那些sql,和developers 核实一下,应该不是正常的应用.重启那个db就好了

select SQL_TEXT from v$sqltext sql,v$session,v$process where v$session.paddr=v$process.addr and v$process.SPID in ('11521','11685','10173','11947','11289','7604') and sql.ADDRESS=v$session.SQL_ADDRESS and sql.HASH_VALUE=v$session.SQL_HASH_VALUE;

ITPub博客

一个db占用太多cpu,该怎样解决

最新文章