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/sunmanagersReceived 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