操作系统:Linux as5
数据库:oracle 10g
登录操作系统使用top
top - 14:07:50 up 519 days, 18:28, 5 users, load average: 0.12, 0.12, 0.12
Tasks: 703 total, 1 running, 702 sleeping, 0 stopped, 0 zombie
Cpu(s): 52.0%us, 0.8%sy, 0.0%ni, 96.8%id, 0.2%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 16597612k total, 15145248k used, 1452364k free, 298672k buffers
Swap: 5111800k total, 39588k used, 5072212k free, 9598120k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20359 oracle 16 0 292m 278m 5064 S 52.3 1.7 21:23.49 oracle
3030 oracle 15 0 2604 1416 800 R 2.0 0.0 0:00.18 top
...
ps -ef |grep ora
oracle 14529 1 0 Oct08 ? 00:01:02 oracleecard (LOCAL=NO)
oracle 14999 1 0 10:48 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17045 1 0 Oct25 ? 00:01:03 oracleecard (LOCAL=NO)
oracle 17095 1 0 Oct25 ? 00:01:31 oracleecard (LOCAL=NO)
oracle 17098 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17101 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17104 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17113 1 0 Oct25 ? 00:00:01 oracleecard (LOCAL=NO)
oracle 17115 1 0 Oct25 ? 00:01:29 oracleecard (LOCAL=NO)
oracle 17120 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17127 1 0 Oct25 ? 00:00:03 oracleecard (LOCAL=NO)
oracle 17131 1 0 Oct25 ? 00:00:02 oracleecard (LOCAL=NO)
oracle 17133 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17139 1 0 Oct25 ? 00:00:02 oracleecard (LOCAL=NO)
oracle 17141 1 0 Oct25 ? 00:00:03 oracleecard (LOCAL=NO)
oracle 17143 1 0 Oct25 ? 00:00:02 oracleecard (LOCAL=NO)
oracle 17153 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17163 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17165 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17167 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17169 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17171 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17173 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17175 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17177 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17179 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17181 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17183 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17185 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO).....................
现在问题是,导致是oracle的什么操作导致系统的CPU使用率高,高分求助。
谢谢。。
数据库:oracle 10g
登录操作系统使用top
top - 14:07:50 up 519 days, 18:28, 5 users, load average: 0.12, 0.12, 0.12
Tasks: 703 total, 1 running, 702 sleeping, 0 stopped, 0 zombie
Cpu(s): 52.0%us, 0.8%sy, 0.0%ni, 96.8%id, 0.2%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 16597612k total, 15145248k used, 1452364k free, 298672k buffers
Swap: 5111800k total, 39588k used, 5072212k free, 9598120k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20359 oracle 16 0 292m 278m 5064 S 52.3 1.7 21:23.49 oracle
3030 oracle 15 0 2604 1416 800 R 2.0 0.0 0:00.18 top
...
ps -ef |grep ora
oracle 14529 1 0 Oct08 ? 00:01:02 oracleecard (LOCAL=NO)
oracle 14999 1 0 10:48 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17045 1 0 Oct25 ? 00:01:03 oracleecard (LOCAL=NO)
oracle 17095 1 0 Oct25 ? 00:01:31 oracleecard (LOCAL=NO)
oracle 17098 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17101 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17104 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17113 1 0 Oct25 ? 00:00:01 oracleecard (LOCAL=NO)
oracle 17115 1 0 Oct25 ? 00:01:29 oracleecard (LOCAL=NO)
oracle 17120 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17127 1 0 Oct25 ? 00:00:03 oracleecard (LOCAL=NO)
oracle 17131 1 0 Oct25 ? 00:00:02 oracleecard (LOCAL=NO)
oracle 17133 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17139 1 0 Oct25 ? 00:00:02 oracleecard (LOCAL=NO)
oracle 17141 1 0 Oct25 ? 00:00:03 oracleecard (LOCAL=NO)
oracle 17143 1 0 Oct25 ? 00:00:02 oracleecard (LOCAL=NO)
oracle 17153 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17163 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17165 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17167 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17169 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17171 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17173 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17175 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17177 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17179 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17181 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17183 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO)
oracle 17185 1 0 Oct25 ? 00:00:00 oracleecard (LOCAL=NO).....................
现在问题是,导致是oracle的什么操作导致系统的CPU使用率高,高分求助。
谢谢。。
用pid去查处sql_text,看什么原因,如果允许就把进程kill掉