From: Shazia Shaheen (shazias78@hotmail.com)
Date: Thu Sep 12 2002 - 03:38:48 EDT
Hello Can any person help me We have SUNFire4800
with 10GB RAM 750Mhz 6 Processor with T3 disk arrays with soalris 8 Application
run on it is oracle 8.0.6cluster 3.0tuxedo 6.5and our billing application as
we start tuxedo and our billing application CPU usage shout to 100 % we
have changed many Kernel parameters but still facing the same problem
while it was running fine on SUN ENTERPRISE E3500.Can any body help me
that we should increse number os CPU or to do some thing for performance
tuning .Here is /etc/system file * Start of lines added by SUNWscr
set rpcmod:svc_default_stksize=0x8000
set ge:ge_intr_mode=0x833
* End of lines added by SUNWscr
* vxvm_START (do not remove)
forceload: drv/vxdmp
forceload: drv/vxio
forceload: drv/vxspec
forceload: drv/sd
forceload: drv/SUNW,isptwo
forceload: drv/pci
forceload: drv/ssm
forceload: drv/ssd
rootdev:/pseudo/vxio@0:0
set vxio:vol_rootdev_is_volume=1
* vxvm_END (do not remove)
* vxfs_START -- do not remove the following lines:
*
* VxFS requires a stack size greater than the default 8K.
* The following values allow the kernel stack size
* for all threads to be increased to 16K.
*
set lwp_default_stksize=0x6000
* vxfs_END
* oracle parameters
*
* Singl.eView changes
**################################################
*###
*## ATTENTION : ANGELA NEWTON
*## Kinly read the following
*## From : Badar Mahmood Ora-Tech Systems
*################################################
*### This file is a copy of /etc/system
*### and was copied from vbill1 and pasted in /etc at nvbill1 and
nvbill2
*### The hashed parameters (*#) are the original settings as in
/etc/system
*### and are the ones which were suggested to be changed. Some
parameters are
*### being suggested to be changed to a lower value kindly confirm that
this IS what is intended.
*### The suggested value has been added and the original parameter is
still
*### kept but hashed out.
*################################################*#set
shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmax=4294967295set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=300
*#set semsys:seminfo_semmap=512
*#DGset semsys:seminfo_semmap=1011
set semsys:seminfo_semmap=512
*#DGset semsys:seminfo_semume=1011
set semsys:seminfo_semume=100
*#DGset semsys:seminfo_semmsl=1011
set semsys:seminfo_semmsl=512
*#set shmsys:shminfo_shmseg=280
*#set shmsys:shminfo_shmseg=10
*#DGset shmsys:shminfo_shmseg=100
set shmsys:shminfo_shmseg=200
*#set semsys:seminfo_semmni=600
*#set semsys:seminfo_semmni=400
*#DGset semsys:seminfo_semmni=1011
set semsys:seminfo_semmni=300*#set semsys:seminfo_semmns=4800
*#set semsys:seminfo_semmns=800
*#DGset semsys:seminfo_semmns=1011
set semsys:seminfo_semmns=4800*#set semsys:seminfo_semmnu=4800
*#set semsys:seminfo_semmnu=800
*#DGset semsys:seminfo_semmnu=1011
set semsys:seminfo_semmnu=4800*#set msgsys:msginfo_msgmap=4800
*#DGset msgsys:msginfo_msgmap=2022
set msgsys:msginfo_msgmap=2050*#set msgsys:msginfo_msgmax=32768
*#DGset msgsys:msginfo_msgmax=131072
set msgsys:msginfo_msgmax=65535*#set msgsys:msginfo_msgmnb=65535
*#DGset msgsys:msginfo_msgmnb=196608
set msgsys:msginfo_msgmnb=65535*#set msgsys:msginfo_msgmni=2400
*#set msgsys:msginfo_msgmni=200
*#DGset msgsys:msginfo_msgmni=1011
set msgsys:msginfo_msgmni=1024*#set msgsys:msginfo_msgssz=32
*#DGset msgsys:msginfo_msgssz=32
set msgsys:msginfo_msgssz=64*#set msgsys:msginfo_msgseg=16384
set msgsys:msginfo_msgseg=32768*#set msgsys:msginfo_msgtql=2400
*#set msgsys:msginfo_msgtql=200
*#DGset msgsys:msginfo_msgtql=1011
set msgsys:msginfo_msgtql=2048*# set nproc=250
set nproc=250* END Singl.eView addition
*
set lotsfree=512
*
* Suggested by Sun
*
forceload:misc/obpsym
set nopanicdebug=1
exclude:lofs
fp:fp_offline_ticker=1
* END Sun Suggestions
*#####New Parameter######
set priority_paging=1
set maxpgio=25468
set slowscan=500
Here is the output of mpstat 5 command mpstat 5
CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt
idl
10 55 0 5978 1300 785 1587 497 73 124 1 2740 64 15 3
17
11 60 0 4679 782 275 1700 534 80 104 2 2892 64 14 4
18
16 56 0 6184 1161 720 1585 499 73 101 1 2753 61 17 3
20
17 58 0 6372 1067 608 1606 508 74 102 1 2789 62 16 3
20
18 60 0 4465 775 266 1705 546 77 109 1 3008 66 14 3
17
19 60 0 4467 836 340 1708 550 76 120 2 2997 65 15 3
17
CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt
idl
10 12 0 7891 2354 1573 2407 910 138 144 0 3348 74 22
1 3
11 35 0 6147 1082 259 2819 1110 142 113 0 4293 87 11
0 3
16 67 0 9411 1975 1349 2161 868 135 110 0 3098 77 21
0 2
17 46 0 10968 1136 562 2060 816 141 98 0 3158 74 22
2 3
18 61 0 4935 981 258 2371 924 151 94 0 4090 80 17
0 3
19 76 0 5196 1089 353 2384 938 154 114 0 3226 84 13
0 3
CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt
idl
10 8 0 7505 2170 1645 1424 596 71 251 1 2085 77 21
0 2
11 9 0 4170 953 255 2506 845 101 187 4 3745 85 12
1 2
16 18 0 10328 1863 1325 1955 750 88 219 0 2971 79 17
1 3
17 40 0 10447 1093 574 1329 530 79 166 2 1509 87 11
1 2
18 82 0 5696 1099 254 2410 903 114 172 6 3246 83 12
2 4
19 24 0 7139 966 318 2231 768 94 208 0 3124 82 15
1 2
CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt
idl
10 28 0 6095 2241 1748 1742 511 139 190 0 2381 76 19
0 5
11 21 0 6855 826 267 2373 697 185 207 0 3505 78 15
2 6
16 102 0 10187 1857 1388 2425 682 173 165 0 3147 70 18
3 9
17 62 0 11652 1134 603 2074 674 156 172 0 2810 76 15
2 7
18 56 0 5096 850 262 2712 854 178 186 0 3664 74 17
2 8
19 47 0 5375 1014 344 2684 817 177 207 0 3461 78 15
2 6 Here is the output of prstat -a PID USERNAME SIZE RSS STATE
PRI NICE TIME CPU PROCESS/NLWP
14144 xps_prd 2057M 2044M sleep 12 0 22:39.53 10% oracle/11
14222 xps_prd 2090M 2075M run 0 0 9:51.47 8.8% oracle/11
14236 xps_prd 2090M 2075M cpu19 11 0 11:39.31 8.7% oracle/11
14129 xps_prd 2065M 2052M cpu18 0 0 14:27.51 7.1% oracle/11
21515 xps_prd 2066M 2051M run 12 0 0:06.12 6.3% oracle/11
14186 xps_prd 2052M 2039M run 10 0 9:13.09 5.6% oracle/11
14271 xps_prd 14M 9816K sleep 10 0 7:14.04 5.5% tresok/4
14229 xps_prd 2090M 2075M sleep 33 0 7:57.19 4.6% oracle/11
4 root 0K 0K sleep 60 - 0:00.00 4.1% cluster/1075
21510 xps_prd 10M 6856K run 22 0 0:03.10 3.8% perl/4
14125 xps_prd 2042M 2029M run 0 0 7:50.35 3.4% oracle/11
14114 xps_prd 2060M 2047M run 8 0 5:17.57 2.3% oracle/11
14102 xps_prd 2043M 2030M sleep 58 0 3:31.17 1.9% oracle/11
14218 xps_prd 2044M 2030M sleep 54 0 1:17.04 1.8% oracle/11
14094 xps_prd 2040M 2027M sleep 38 0 2:15.56 1.4% oracle/11
14130 xps_prd 29M 22M sleep 53 0 3:05.43 1.1% trerwdb/4
14228 xps_prd 20M 15M sleep 33 0 0:39.07 0.9% trerodb/4
14128 xps_prd 27M 21M sleep 54 0 2:05.04 0.8% trerwdb/5
14119 xps_prd 26M 19M sleep 53 0 1:18.00 0.8% trerwdb/4
14182 xps_prd 2037M 2023M run 28 0 4:29.17 0.6% oracle/1
14213 xps_prd 2044M 2029M sleep 58 0 0:29.24 0.6% oracle/11
14081 xps_prd 2037M 2024M sleep 58 0 1:22.37 0.6% oracle/1
13967 xps_prd 9400K 7944K sleep 33 0 1:26.32 0.4% TMUSREVT/1
14273 xps_prd 14M 9440K sleep 33 0 0:37.13 0.4% tresok/4
14107 xps_prd 25M 18M sleep 55 0 0:48.06 0.4% trerwdb/4
14217 xps_prd 19M 14M sleep 48 0 0:14.48 0.4% trerodb/4
14272 xps_prd 2035M 2020M sleep 58 0 0:25.45 0.3% oracle/1
14179 xps_prd 21M 13M sleep 59 0 0:13.16 0.3% trerwdb/5
14183 xps_prd 22M 14M sleep 58 0 0:27.58 0.3% trerwdb/5
1783 oracle 2037M 2019M sleep 58 0 0:08.43 0.3% oracle/25
14249 xps_prd 17M 12M sleep 58 0 0:13.06 0.1% trerodb/4
6585 oracle 2036M 2022M sleep 58 0 0:00.03 0.1% oracle/1
14101 xps_prd 24M 18M sleep 58 0 0:30.06 0.1% trerwdb/4
NPROC USERNAME SIZE RSS MEMORY TIME
CPU
172 xps_prd 131G 128G 31% 143:24.11 81%
61 root 268M 151M 0.0% 0:07.03 4.2%
150 oracle 294G 292G 69% 0:59.52 0.8%
3 asghar 5304K 4104K 0.0% 0:00.00 0.0%
1 afzaal 1048K 888K 0.0% 0:00.00 0.0%
3 spmadmin 63M 6976K 0.0% 0:00.00 0.0%
1 daemon 2544K 1768K 0.0% 0:00.00 0.0% Total: 391 processes,
2600 lwps, load averages: 8.37, 10.13, 11.04
$ Thanks in advance Regards Shazia
------------------------------------------------------------------------
MSN Photos is the easiest way to share and print your photos: Click Here
_______________________________________________
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:24:55 EDT