From: durgads@charteredsemi.com
Date: Thu May 22 2003 - 04:00:47 EDT
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:27 EDT