SUMMARY: Cpu Idel 0%

From: <durgads_at_charteredsemi.com>
Date: Mon Jun 02 2003 - 01:46:59 EDT
Hi All,

First of all, thank you to everybody that helped me.

Our DBA was enabled audit in oracle database, some thing was wrong in
database autit querries so that orcale was eating system resources. Once
disable audit in oracle DB system is working fine.

Thanks,
Shanker Durgad.

----- Forwarded by DURGAD Shanker/IT/CHRT/ST Group on 02/06/2003 01:42 PM
-----
DURGAD Shanker/IT/CHRT/ST Group     22/05/2003 04:00 PM
                                                                                                                                       
              To:  sunmanagers@sunmanagers.org                                                                                         
              cc:                                                                                                                      
              Subject: Cpu Idel 0%                                                                                                     
                                                                                                                                       
                                                                                                                                       
                                                                                                                                       


[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]

Hi Guru`s,

I have E3500 server with 2* T3 storage. Presently my system resource are
being used by oracle id, could any one tell me which is culprit.

--------------------------------------------------------------------------------------------------------------------------
#prstat -ac

 PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP
 16665 oracle    899M  877M run     30    0   6:17.16  11% oracle/11
  8866 oracle    897M  875M run     59    0   3:03.39 9.5% oracle/1
  7245 oracle    897M  874M cpu15   59    0   0:19.33 9.4% oracle/1
  3137 oracle    897M  874M cpu18   31    0   0:35.36 9.3% oracle/1
  1482 oracle    897M  874M run     31    0   1:20.30 9.2% oracle/1
  4746 oracle    897M  874M run     31    0   0:30.03 9.2% oracle/1
  9790 oracle    897M  873M sleep   59    0   0:00.19 9.1% oracle/1
  3004 oracle    897M  875M run     30    0   3:32.11 8.5% oracle/1
  8921 oracle    897M  874M cpu19   41    0   0:09.36 8.3% oracle/1
  9785 oracle    897M  874M run     31    0   0:00.18 8.0% oracle/1
 11077 oracle    897M  875M run     36    2   6:07.30 4.9% oracle/1
  7243 oracle     15M 9760K sleep   48    2   0:00.13 0.3% smpCP_lucent/4
 25622 oracle    898M  876M sleep   42    0   0:02.29 0.1% oracle/1
  1305 oracle    898M  871M sleep   59    0   0:15.04 0.1% oracle/11
  9112 oracle   1840K 1472K sleep   53    2   0:00.04 0.1% ftp/1
 NPROC USERNAME  SIZE   RSS MEMORY      TIME  CPU
   103 oracle     32G   31G   100%  23:56.19  97%
    84 root      333M  152M   0.5%   0:06.26 0.1%
     2 license  4984K 3776K   0.0%   0:00.15 0.0%
     1 daemon   2496K 1744K   0.0%   0:00.00 0.0%
Total: 190 processes, 691 lwps, load averages: 11.77, 11.99, 12.04
----------------------------------------------------------------------------------------------------------------------------------
 /usr/ucb/ps -aux |more

USER       PID %CPU %MEM   SZ  RSS TT       S    START  TIME COMMAND
oracle    4746  9.6 22.2918408894576 ?        O 14:07:05 30:45
oracleF3ymsprod (D
oracle   16665  9.4 22.3920472897928 ?        O 17:00:02 378:00
oracleF3ymsprod (D
oracle    7245  8.5 22.2918472894608 ?        O 14:53:46 20:15
oracleF3ymsprod (D
oracle    3137  8.4 22.2918424894496 ?        O 13:51:19 36:16
oracleF3ymsprod (D
oracle    9790  8.2 22.2918480894600 ?        S 15:50:24  1:03
oracleF3ymsprod (D
oracle    9785  8.2 22.2918400894536 ?        R 15:50:24  0:57
oracleF3ymsprod (D
oracle    1482  8.0 22.2918408894464 ?        R 10:37:30 81:10
oracleF3ymsprod (D
oracle    3004  8.0 22.3918408895552 ?        O 22:45:03 212:51
oracleF3ymsprod (D
oracle    8921  7.8 22.2918400894568 ?        R 15:23:05 10:16
oracleF3ymsprod (D
oracle    8866  7.8 22.3918584895800 ?        S 00:24:59 184:19
oracleF3ymsprod (D
oracle   11077  5.5 22.3918512895896 ?        R   May 19 367:54
oracleF3ymsprod (D
oracle    9566  4.7 22.4922696900048 ?        R 15:37:21  0:51
oracleF3ymsprod (D
oracle    9811  1.9 22.3918448895456 ?        S 15:51:35  0:07
oracleF3ymsprod (D
oracle   25622  1.7 22.3919152896584 ?        S 09:26:41  2:34
oracleF3ymsprod (D
root         3  0.7  0.0    0    0 ?        O   May 14 277:38 fsflush
oracle    9816  0.2 22.2918376893968 ?        S 15:51:45  0:02
oracleF3ymsprod (D
oracle    1305  0.1 22.2919760891552 ?        S   May 14 68:34
ora_lgwr_F3ymsprod
oracle    9788  0.1  0.212912 6336 ?        S 15:50:24  0:00 fab2CP
FS311025_W0
root      9832  0.1  0.1 1736 1312 pts/23   O 15:53:11  0:00 /usr/ucb/ps
-aux
root       571  0.1  0.1 4152 3712 ?        S   May 14  8:03 mibiisa -r -p
3278
oracle    9822  0.1  0.1 1816 1184 pts/24   R 15:52:58  0:00 -ksh
-----------------------------------------------------------------------------------------------------------------------------


Thanks,
Shanker.


[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
Received on Mon Jun 2 01:50:16 2003

This archive was generated by hypermail 2.1.8 : Thu Mar 03 2016 - 06:43:11 EST