From: Dhotre, Shekhar (Shekhar.Dhotre@T-T.COM)
Date: Wed Aug 07 2002 - 10:17:51 EDT
Hi All ,
I have oracle 8.1.6 running on spnode5(4 CPU`s ) .Due to performance
problem I opened a PMR with IBM .
IBM asked me to run permgr script on this box to collect perf statistics.
After validating results - they found that
1)Oracle is not multithreaded(svmon -P PID) results
2)Oracle is not using all 4 cpu`s (Sar output )
and that's where problem is .
I forwarded IBM`s results to DBA group ,Now DBA group came up with there own
finding :
Following are the results of some querries Oracle recommended concerning
this issue:
1. This will show the number of cpu's Oracle is seeing from the OS, Check
this view to ensure that Oracle is seeing all of your CPU's
SVRMGR> select value from v$parameter where NAME='cpu_count';
VALUE
----------------------------------------------------------
4
2. To find out # of CPU's on AIX, type:
/usr/sbin/bindprocessor -q , for each CPU present and id will be shown
bindprocessor -q
The available processors are: 0 1 2 3
This number should match that in the cpu_count. Ensure that there really
are as many CPU's as you think there are.
So it look like Oracle is seeing all 4 CPU's
Thanks .
DBA group
Can someone explain me how multithreading and cpu use is related to each
other ? Is oracle not using all cpu`s because
It is not multithreaded ? How to configure AIX/oracle so that oracle will
use e all 4 cpu`s ? What does svmon shows on your systems ?
Thanks
Shekhar Dhotre
Unix admin
Boston ,MA-02071.
USA.
# ps -ef | grep oracle
oracle 25264 1 0 08:23:28 - 0:01 oracleDWP1 (LOCAL=NO)
oracle 32758 1 0 Aug 04 - 0:03 oracleDWP1
(DESCRIPTION=(LOCAL=
YES)(ADDRESS=(PROTOCOL=beq)))
oracle 33508 1 0 Aug 04 - 0:01 ora_pmon_DWP1
oracle 46988 1 0 Aug 04 - 0:00 ora_reco_DWP1
oracle 50636 75730 0 09:15:40 pts/3 0:00 -ksh
oracle 58450 88722 0 09:15:58 - 0:00 oracleDWP1
(DESCRIPTION=(LOCAL=
YES)(ADDRESS=(PROTOCOL=beq)))
oracle 59420 1 0 08:23:31 - 0:00 oracleDWP1 (LOCAL=NO)
oracle 59786 1 0 Aug 04 - 0:11 ora_dbw0_DWP1
oracle 63398 1 0 Aug 04 - 2:43 ora_ckpt_DWP1
oracle 67546 1 0 18:35:35 - 0:00 oracleDWP1 (LOCAL=NO)
idw 69418 1 120 07:25:09 - 123:04 oracleDWP1
(DESCRIPTION=(LOCAL
=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 76188 96772 0 Jun 20 - 75:49 dbsnmp
oracle 78506 1 0 09:17:16 - 0:00 oracleDWP1 (LOCAL=NO)
idw 79062 104920 0 16:58:10 - 20:00 oracleDWP1
(DESCRIPTION=(LOCAL=
YES)(ADDRESS=(PROTOCOL=beq)))
oracle 81074 1 0 Aug 04 - 0:05 ora_smon_DWP1
oracle 84480 1 0 17:34:03 - 0:00 oracleDWP1 (LOCAL=NO)
oracle 88500 88722 0 09:17:31 pts/3 0:00 /usr/bin/ksh
oracle 88722 50636 0 09:15:58 pts/3 0:00 svrmgrl
oracle 88878 1 0 Aug 04 - 1:23 ora_lgwr_DWP1
root 90982 27410 2 09:30:44 pts/4 0:00 grep oracle
oracle 96772 1 0 Jun 20 - 34:37 dbsnmp
oracle 98194 1 0 Aug 04 - 0:03 oracleDWP1
(DESCRIPTION=(LOCAL=
YES)(ADDRESS=(PROTOCOL=beq)))
oracle 103568 1 0 09:17:15 - 0:00 oracleDWP1 (LOCAL=NO)
oracle 105116 1 0 Jun 20 - 7:52
/f1s5_07582/u01/app/oracle/prod
uct/8.1.6/bin/tnslsnr LISTENER -inherit
# svmon -P 59420
----------------------------------------------------------------------------
---
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd
59420 oracleDWP1 181921 3083 207269 244235 N N
Vsid Esid Type Description Inuse Pin Pgsp Virtual Addr
Range
d002 4 work shmat/mmap 62119 0 60182 65536
0..65535
26cf0 3 work shmat/mmap 61591 0 62295 65536
0..65535
370df 5 work shmat/mmap 27624 0 21917 28951
0..61714
65a3 6 work shmat/mmap 14630 0 51271 62123
0..65535
1f32c 7 work shmat/mmap 9452 0 9869 17568 0..37322
0 0 work kernel seg 3387 3082 1671 4154 0..23689
:
65474..65535
235b1 1 pers code,/dev/hd_07582_u 2184 0 - - 0..10093
3801c d work shared library text 621 0 38 45 0..65535
10ccb 2 work process private 252 1 19 271 0..331 :
65306..65535
29130 f work shared library data 57 0 7 51 0..1834
14c3 - pers /dev/hd_07582_u01:43 4 0 - - 0..86
FRom IBM
2. The oracle appliction that is running on the system is only using one
cpu base on the following sar output.
21:24:57 cpu %usr %sys %wio %idle
21:25:08 0 7 15 23 55
1 13 11 10 65
2 8 16 23 53
3 71 6 9 13
- 25 12 16 47
21:25:18 0 9 12 5 74
1 3 11 2 84
2 5 18 2 74
3 83 4 1 11
- 25 11 3 61
21:25:28 0 3 16 7 74
1 61 3 6 29
2 4 10 5 81
3 26 12 6 56
- 24 10 6 60
21:25:38 0 6 15 6 73
1 0 9 4 87
2 0 10 3 86
3 94 1 0 5
- 25 9 3 63
21:25:48 0 0 8 2 90
1 0 13 4 83
2 0 10 4 85
3 99 1 0 0
- 25 8 3 65
21:25:58 0 0 9 5 86
1 45 3 3 49
2 2 9 6 83
3 52 8 3 38
- 25 7 4 64
21:26:08 0 0 5 9 86
1 44 7 16 33
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:07 EDT