From: durgads@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
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:30 EDT