Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 18 73.94
log file sync 138 4 14.95
log file parallel write 441 1 3.43
control file sequential read 54 1 2.65
db file parallel write 32 0 2.04
-------------------------------------------------------------
Wait Events for DB: DEV Instance: dev Snaps: 49 -50
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)CPU使用率高不高是看这一栏的值吗?Total Time的值高就是高?
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 18 73.94
log file sync 138 4 14.95
log file parallel write 441 1 3.43
control file sequential read 54 1 2.65
db file parallel write 32 0 2.04
-------------------------------------------------------------
Wait Events for DB: DEV Instance: dev Snaps: 49 -50
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)CPU使用率高不高是看这一栏的值吗?Total Time的值高就是高?
解决方案 »
- 求助!win7(32位)下不完全卸载oracle11后,重装出现keyexists,如何处理?
- 可能涉及递归算法的SQL难题,求高手当头棒喝:嘿!你这呆子!!
- 怎样查看所定义过的存储过程列表,另外查看某个存储过程的定义吗
- 请问SQLPLUS中怎么得到通过数据库返回的变量,再利用这个变量创建表呢
- 为什么oracle占用的磁盘空间自动增长?
- 高手过来看看吧:oracle10g数据导入时出现问题
- 数据导入时出错,请大家帮忙看看
- 为什么我用oci调用存储过程总是提示character string buffer too small
- 我希望返回一个动态记录集,有什么好办法
- oracle xmlelement 单引号会变'
- oracle中普通表空间最大能扩展为多少?BIGFILE最大能扩展为多少?
- 求oracle两个存储过程
windows之间看任务管理器就可以了linux下看CPU,敲入top就能看到了..
[root@sfzxkf scripts]# toptop - 15:01:27 up 56 days, 32 min, 2 users, load average: 2.65, 1.97, 1.72
Tasks: 108 total, 2 running, 106 sleeping, 0 stopped, 0 zombie
Cpu(s): 58.5% us, 5.3% sy, 0.0% ni, 35.9% id, 0.1% wa, 0.0% hi, 0.2% si
Mem: 4041348k total, 3933700k used, 107648k free, 288756k buffers
Swap: 4096564k total, 158412k used, 3938152k free, 2176196k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18363 mysql 16 0 333m 120m 2672 S 199.9 3.1 39138:23 mysqld
17682 apache 16 0 1417m 78m 2296 S 20.3 2.0 3:03.66 httpd
18009 root 15 0 1595m 414m 10m S 20.3 10.5 55:08.14 java
18092 apache 16 0 1412m 74m 2300 S 14.3 1.9 2:15.44 httpd
532 root 15 0 0 0 0 S 0.3 0.0 4:44.26 kjournald
19863 root 16 0 6172 1156 852 R 0.3 0.0 0:00.01 top
1 root 16 0 4772 468 436 S 0.0 0.0 0:10.68 init
2 root RT 0 0 0 0 S 0.0 0.0 0:05.47 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:05.98 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:01.86 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.72 ksoftirqd/1
6 root RT 0 0 0 0 S 0.0 0.0 0:02.26 migration/2