top - 08:44:15 up 3 days, 17:45,  2 users,  load average: 9.02, 9.02, 9.70
Tasks: 475 total,   3 running, 471 sleeping,   0 stopped,   1 zombie
Cpu(s): 14.0%us,  0.7%sy,  0.0%ni, 74.2%id, 10.9%wa,  0.0%hi,  0.3%si,  0.0%st
Mem:  32938504k total,  7507756k used, 25430748k free,   227876k buffers
Swap:  4192956k total,        0k used,  4192956k free,  4978704k cached

解决方案 »

  1.   

    CPU使用率高,内存完全没有问题,你的操作系统多少位的?是不是无法使用大内存?看看哪些进程耗CPU,TOP前几个进程看看TOP -C
      

  2.   

    2users,就占用这么高,还是TOP C 看看前几位的进程吧!
      

  3.   

    Tasks: 489 total,   2 running, 486 sleeping,   0 stopped,   1 zombie
    Cpu(s):  8.7%us,  1.3%sy,  0.0%ni, 70.7%id, 18.7%wa,  0.1%hi,  0.5%si,  0.0%st
    Mem:  32938504k total,  7663380k used, 25275124k free,   229024k buffers
    Swap:  4192956k total,        0k used,  4192956k free,  4980804k cached  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                         
    32749 oracle    16   0 5313m 1.0g 1.0g D 22.1  3.2   0:26.84 oracleorcl1 (LOCAL=NO)                                                                          
    31150 oracle    16   0 5313m 1.0g 1.0g D 21.5  3.2   0:38.15 oracleorcl1 (LOCAL=NO)                                                                          
     4419 oracle    15   0 5313m 662m 656m D 21.1  2.1   0:08.98 oracleorcl1 (LOCAL=NO)                                                                          
    27278 oracle    15   0 5313m 1.3g 1.3g S 15.9  4.0   1:02.14 oracleorcl1 (LOCAL=NO)                                                                          
    32745 oracle    15   0 5313m 1.1g 1.0g S  8.3  3.3   0:17.01 oracleorcl1 (LOCAL=NO)                                                                          
    10991 oracle    -2   0 5320m 2.4g 2.4g S  6.9  7.6  81:23.91 ora_lms1_orcl1                                                                                  
    10987 oracle    -2   0 5320m 2.4g 2.4g S  6.3  7.6  75:44.10 ora_lms0_orcl1                                                                                  
     7611 oracle    15   0 5322m 3.0g 3.0g D  5.9  9.7 157:59.49 ora_j000_orcl1                                                                                  
     8058 root      15   0  123m  14m 6628 S  5.0  0.0   0:22.03 /usr/bin/Xorg :0 -br -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7                         
    27126 oracle    15   0 5311m 390m 385m S  5.0  1.2   0:30.00 oracleorcl1 (LOCAL=NO)                                                                          
      301 oracle    16   0 5313m 830m 824m S  4.6  2.6   0:20.03 oracleorcl1 (LOCAL=NO)                                                                          
     9233 oracle    15   0 5314m 3.0g 3.0g D  4.3  9.6  93:10.38 ora_j001_orcl1                                                                                  
     4009 oracle    15   0 5310m 176m 172m S  4.0  0.5   0:01.01 oracleorcl1 (LOCAL=NO)                                                                          
     4463 oracle    15   0 5313m 477m 472m S  3.6  1.5   0:03.68 oracleorcl1 (LOCAL=NO)                                                                          
    27630 oracle    16   0 5313m 1.1g 1.1g D  3.0  3.6   0:51.21 oracleorcl1 (LOCAL=NO)                                                                          
     4934 oracle    15   0 5313m 500m 494m S  2.6  1.6   0:02.63 oracleorcl1 (LOCAL=NO)                                                                          
    31139 oracle    15   0 5313m 989m 983m S  2.6  3.1   0:25.28 oracleorcl1 (LOCAL=NO)                                                                          
    10985 oracle    15   0 5317m 375m 362m S  2.3  1.2  33:22.15 ora_lmd0_orcl1                                                                                  
    27369 oracle    16   0 5315m 1.3g 1.3g D  2.3  4.2   0:47.99 oracleorcl1 (LOCAL=NO)                                                                          
      590 oracle    16   0 5313m 919m 912m D  2.0  2.9   0:17.11 oracleorcl1 (LOCAL=NO)                                                                          
     4456 oracle    16   0 5313m 686m 680m D  2.0  2.1   0:17.86 oracleorcl1 (LOCAL=NO)                                                                          
     4413 oracle    16   0 5313m 685m 679m D  1.7  2.1   0:08.07 oracleorcl1 (LOCAL=NO)                                                                          
     4439 oracle    15   0 5315m 133m 128m S  1.7  0.4   0:01.24 oracleorcl1 (LOCAL=NO)                                                                          
    31141 oracle    16   0 5315m 1.1g 1.1g D  1.7  3.4   0:31.23 oracleorcl1 (LOCAL=NO)                                                                          
     5320 oracle    18   0 5315m 547m 541m D  1.3  1.7   0:07.69 oracleorcl1 (LOCAL=NO)                                                                          
     4415 oracle    16   0 5313m 540m 534m D  1.0  1.7   0:05.61 oracleorcl1 (LOCAL=NO)                                                                          
    32751 oracle    16   0 5313m 1.0g 1.0g D  1.0  3.3   0:22.67 oracleorcl1 (LOCAL=NO)                                                                          
     3118 root      15   0  331m  16m 9400 S  0.7  0.1   0:01.95 gnome-terminal                                                                                  
     4454 oracle    15   0 5313m  98m  93m S  0.7  0.3   0:00.62 oracleorcl1 (LOCAL=NO)                                                                          
     5919 root      15   0 13000 1400  816 R  0.7  0.0   0:00.20 top -c                                                                                          
    11003 oracle    15   0 5327m  97m  93m S  0.7  0.3   8:01.56 ora_lgwr_orcl1                                                                                  
     5301 oracle    15   0 5315m 206m 201m S  0.3  0.6   0:02.20 oracleorcl1 (LOCAL=NO)                                                                          
     7309 root      19   0 11048 1352  932 S  0.3  0.0   9:20.40 /bin/sh /etc/init.d/init.cssd fatal                                                             
     8932 oracle    RT   0  432m 286m  39m S  0.3  0.9   7:22.20 /u01/app/crs/product/11.1.0/crs/bin/ocssd.bin                                                   
    10981 oracle    15   0 5433m 250m 156m S  0.3  0.8  55:13.16 ora_dia0_orcl1                                                                                  
    10983 oracle    15   0 5315m 568m 560m S  0.3  1.8  23:25.15 ora_lmon_orcl1                                                                                  
    11017 oracle    15   0 5306m 270m 266m S  0.3  0.8   4:08.83 ora_mmnl_orcl1                                                                                  
    11045 oracle    15   0 5315m 1.0g 997m S  0.3  3.1  12:26.24 ora_lck0_orcl1                                                                                  
    32760 oracle    15   0 5311m 239m 234m S  0.3  0.7   0:05.54 oracleorcl1 (LOCAL=NO)                                                                          
        1 root      15   0 10344  680  572 S  0.0  0.0   0:05.04 init [5]                                                                                        
        2 root      RT  -5     0    0    0 S  0.0  0.0   0:00.03 [migration/0]                                                                                   
        3 root      34  19     0    0    0 S  0.0  0.0   0:00.08 [ksoftirqd/0]                                                                                   
        4 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 [watchdog/0]   
      

  4.   

    上面是用top c命令出来的结果。求大鳄帮忙看看
      

  5.   

    看来都是ORACLE的进程再跑,看看AWR里的TOP事件,看看耗CPU的语句和是否有锁
      

  6.   

    awr 怎么用啊 我看很多语句啊 你要哪个啊 能看出来
      

  7.   

    sql ordered by cpu time
      

  8.   

    最好能抓到具体的sql,看看执行计划什么的,优化sql,是不是没有使用绑定变量什么的,导致全是硬解析~~
      

  9.   

    先看一下SGA,与PGA的大小,这个很重要!