From: Dhotre, Shekhar (Shekhar.Dhotre@T-T.COM)
Date: Thu Aug 08 2002 - 12:05:00 EDT
What does sar -P ALL 1 10 and svmon -P pid of oracle shows ?
IBM response follows :
Shekhar,
In the pstat output you can see that oracle is using two cpus, but also
notice that the process id are difference for both processes. The oracle
process is a single threaded process that must create another process to
use more than one cpu. If the oracle process does not create a new child
process it will only use one cpu. The only reason that I am pointing to
oracle as the performance problem is that the system does not have a
bottleneck and the only thing that could be effect the performance of the
application is the application itself. If you run the sar -P ALL 1 10 you
will be able to see that only on cpu is being used the most and that the
other cpus are sitting idle. If you had a multithreaded application all
the cpus would be used more evenly.
Thank you,
Sergio Gaitan
AIX Technical Specialist
System Performance Team
-----Original Message-----
From: Ken_Sedlacek@KYRUS.COM [mailto:Ken_Sedlacek@KYRUS.COM]
Sent: Thursday, August 08, 2002 11:28 AM
To: aix-l@Princeton.EDU
Subject: Re: Multithreading AIX /Oracle question
okay. I understand what you have said up to this point.
Here is my pstat -S
root:/u01># pstat -S
STATUS OF PROCESSORS:
CPU TID TSLOT PID PSLOT PROC_NAME
0 205 2 204 2 no wait
1 307 3 306 3 no wait
2 241db 577 75a2 117 no pstat
3 9f59 159 19566 405 no oracle
However, I did the pstat -S several more times (5 or so), and I never saw
oracle in the PROC_NAME column in any of those times.
Ex:
root:/u01># pstat -S
STATUS OF PROCESSORS:
CPU TID TSLOT PID PSLOT PROC_NAME
0 205 2 204 2 no wait
1 307 3 306 3 no wait
2 409 4 408 4 no wait
3 27dd3 637 7048 112 no pstat
Maybe oracle is running in the other CPUs, but we never see it due to
timing of the pstat command.
We are running Oracle 8.0.5. I don't know if that would make a difference.
Ken Sedlacek
AIX/TSM/UNIX Administrator
ksedlacek@kyrus.com
IBM Certified Specialist: RS/6000 AIX v4.3 Support
IBM Certified Specialist: RS/6000 SP & PSSP 3
Tivoli Certified Consultant - Tivoli Storage Manager v4.1
"Dhotre,
Shekhar" To: aix-l@Princeton.EDU
<Shekhar.Dhotr cc:
e@T-T.COM> Subject: Re: Multithreading AIX
/Oracle question
Sent by: IBM
AIX Discussion
List
<aix-l@Princet
on.EDU>
08/08/2002
10:52 AM
Please respond
to IBM AIX
Discussion
List
>If the answer to #1 & #2 above is that there is the same # of CPUs in AIX
>and in Oracle, then what makes you believe that Oracle is not working
>multithreading or not working right?? next column to 64bit -
svmon -P pid of oracle process shows it's not multithreaded .
# svmon -P 97262
----------------------------------------------------------------------------
-
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd
97262 oracleDWP1 274384 3083 258140 267217 N N
Vsid Esid Type Description Inuse Pin Pgsp Virtual Addr
Rang
3705f - pers large file /dev/hd_0 63333 0 - -
0..486403
d002 4 work shmat/mmap 56610 0 65077 65536
0..65535
26cf0 3 work shmat/mmap 55722 0 64624 65536
0..65535
5006 - pers large file /dev/hd_0 50860 0 - -
0..384003
370df 5 work shmat/mmap 25258 0 45259 47703
0..65535
1f32c 7 work shmat/mmap 6668 0 15941 17569
0..37322
293d7 - pers large file /dev/hd_0 5128 0 - -
0..384003
0 0 work kernel seg 3367 3082 1671 4154
0..23689
65474..65
1afe9 - pers large file /dev/hd_0 2568 0 - -
0..384003
235b1 1 pers code,/dev/hd_07582_u 1874 0 - -
0..10093
65a3 6 work shmat/mmap 1315 0 65530 65536
0..65535
3715f 2 work process private 1086 1 0 1086 0..1143
:
65301..65
3801c d work shared library text 523 0 38 45
0..65535
3105 f work shared library data 70 0 0 52 0..1834
14c3 - pers /dev/hd_07582_u01:43 2 0 - - 0..86
pstat -S - shows Oracle is using only one cpu out of 4 .
# pstat -S
STATUS OF PROCESSORS:
CPU TID TSLOT PID PSLOT PROC_NAME
0 11d49 285 6bc6 107 no crash
1 307 3 306 3 no wait
2 409 4 408 4 no wait
3 18aa3 394 e8e4 232 no oracle
>although I don't understand what the question is??
The question is simple : oracle sees all 4 cpu`s but doesn't use them
,Why?
in above output you will see oracle is running only on #3 cpu .Is it
because oracle is not multithreaded (svmon -P output) ?
# lscfg -vp | grep proc | wc -l
4
-----Original Message-----
From: Ken_Sedlacek@KYRUS.COM [mailto:Ken_Sedlacek@KYRUS.COM]
Sent: Thursday, August 08, 2002 10:20 AM
To: aix-l@Princeton.EDU
Subject: Re: Multithreading AIX /Oracle question
>From your original listserv email:
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
Shekhar:
If the answer to #1 & #2 above is that there is the same # of CPUs in AIX
and in Oracle, then what makes you believe that Oracle is not working
multithreading or not working right??
I have an Oracle enviro on a H70 (AIX 4.3.3.06) and am interested in any
answers from the listserv about this question, although I don't understand
what the question is??
Ken Sedlacek
AIX/TSM/UNIX Administrator
ksedlacek@kyrus.com
IBM Certified Specialist: RS/6000 AIX v4.3 Support
IBM Certified Specialist: RS/6000 SP & PSSP 3
Tivoli Certified Consultant - Tivoli Storage Manager v4.1
"Dhotre,
Shekhar" To: aix-l@Princeton.EDU
<Shekhar.Dhotr cc:
e@T-T.COM> Subject: Multithreading AIX
/Oracle question
Sent by: IBM
AIX Discussion
List
<aix-l@Princet
on.EDU>
08/08/2002
09:48 AM
Please respond
to IBM AIX
Discussion
List
Hi All,
I did not received any response to my previous query on this thread ,So
posting again . Anyone out there who can tell me how to make oracle use
all
4 cpu`s ? or how to enable multithreading in AIX /Oracle So that Oracle can
use all 4 cpu`s available .Also How does your systems responds to pstat -S
and svmon ?
http://www.dba-oracle.com/art_ops1.htm - meanwhile I am collecting on
multiprocessing and multithreading ..
System configuration Info :
# uname -a
AIX spnode5 3 4 000075824C00
# pstat -S
STATUS OF PROCESSORS:
CPU TID TSLOT PID PSLOT PROC_NAME
0 11d49 285 6bc6 107 no crash
1 307 3 306 3 no wait
2 409 4 408 4 no wait
3 18aa3 394 e8e4 232 no oracle
# svmon -P 97238
----------------------------------------------------------------------------
---
Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd
97238 oracleDWP1 162725 3083 257917 265787 N N
Vsid Esid Type Description Inuse Pin Pgsp Virtual Addr
Range
d002 4 work shmat/mmap 61180 0 65060 65536
0..65535
26cf0 3 work shmat/mmap 60211 0 64551 65536
0..65535
370df 5 work shmat/mmap 26304 0 45030 46958
0..65535
1f32c 7 work shmat/mmap 5257 0 15941 17569
0..37322
0 0 work kernel seg 3367 3082 1671 4154
0..23689
:
65474..65535
235b1 1 pers code,/dev/hd_07582_u 2294 0 - -
0..10093
34fbe - pers large file /dev/hd_0 894 0 - -
0..384003
3321a - pers large file /dev/hd_0 812 0 - -
0..128003
65a3 6 work shmat/mmap 760 0 65530 65536
0..65535
36fff - pers large file /dev/hd_0 756 0 - -
0..76803
3801c d work shared library text 481 0 38 45
0..65535
18caf 2 work process private 336 1 67 401 0..454
:
65300..65535
3f31c f work shared library data 38 0 29 52 0..1834
371d8 - pers large file /dev/hd_0 28 0 - -
0..384003
4fc6 - pers large file /dev/hd_0 4 0 - -
0..384003
14c3 - pers /dev/hd_07582_u01:43 3 0 - - 0..86
# df -k
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 73728 42948 42% 2452 7% /
/dev/hd2 1081344 81796 93% 25515 10% /usr
/dev/hd9var 114688 98380 15% 493 2% /var
/dev/hd3 499712 360928 28% 686 1% /tmp
/dev/hd1 57344 47240 18% 84 1% /home
/dev/hdhacmp 16384 13616 17% 341 9% /hacmp
/dev/hd_07582_arch 2621440 2616076 1% 18 1%
/f1s5_07582/arch
/dev/hd_07582_data 2097152 1513024 28% 1141 1%
/f1s5_07582/data
/dev/hd_07582_home 65536 63420 4% 21 1%
/f1s5_07582/home
/dev/hd_07582_oradmp 10485760 4813524 55% 67 1%
/f1s5_07582/ora
dmp
/dev/hd_07582_sybase 393216 201436 49% 1432 2%
/f1s5_07582/syb
ase
/dev/hd_07582_u01 3080192 1329984 57% 7188 1%
/f1s5_07582/u01
/dev/hd_07582_u02 4718592 606028 88% 23 1%
/f1s5_07582/u02
/dev/hd_07582_u03 5242880 309892 95% 24 1%
/f1s5_07582/u03
/dev/hd_07582_u04 4718592 606028 88% 23 1%
/f1s5_07582/u04
/dev/hd_07582_u05 4718592 1636608 66% 21 1%
/f1s5_07582/u05
/dev/hd_07582_u06 3670016 590156 84% 21 1%
/f1s5_07582/u06
/dev/hd_07582_u07 5767168 536496 91% 83 1%
/f1s5_07582/u07
/dev/hd_07582_u08 5242880 561932 90% 24 1%
/f1s5_07582/u08
/dev/hd_07582_u09 3670016 528436 86% 23 1%
/f1s5_07582/u09
/dev/hd_07582_u10 4194304 989944 77% 25 1%
/f1s5_07582/u10
/dev/hd_07582_u11 5242880 162560 97% 24 1%
/f1s5_07582/u11
/dev/hd_07582_u12 5242880 214040 96% 22 1%
/f1s5_07582/u12
# lsattr -El mem0
size 2552 Total amount of physical memory in Mbytes False
goodsize 2552 Amount of usable physical memory in Mbytes False
# lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto
Type
paging00 hdisk0 rootvg 1024MB 64 yes yes
lv
hd6 hdisk1 rootvg 1024MB 64 yes yes
lv
#
# EMC SAN (clarion4700)
# lscfg -v | grep fchan
fchan0 20-58 Emulex LP8000 Fibre Channel Adapter
fchan1 20-68 Emulex LP8000 Fibre Channel Adapter
fchan0.1 20-58-01 Emulex LP8000 Fibre Channel Adapter
fchan0.2 20-58-02 Emulex LP8000 Fibre Channel Adapter
fchan0.3 20-58-03 Emulex LP8000 Fibre Channel Adapter
fchan0.4 20-58-04 Emulex LP8000 Fibre Channel Adapter
fchan0.5 20-58-05 Emulex LP8000 Fibre Channel Adapter
fchan0.6 20-58-06 Emulex LP8000 Fibre Channel Adapter
fchan0.7 20-58-07 Emulex LP8000 Fibre Channel Adapter
fchan0.8 20-58-08 Emulex LP8000 Fibre Channel Adapter
fchan0.9 20-58-09 Emulex LP8000 Fibre Channel Adapter
fchan0.10 20-58-0A Emulex LP8000 Fibre Channel Adapter
fchan0.11 20-58-0B Emulex LP8000 Fibre Channel Adapter
fchan0.12 20-58-0C Emulex LP8000 Fibre Channel Adapter
fchan0.13 20-58-0D Emulex LP8000 Fibre Channel Adapter
fchan0.14 20-58-0E Emulex LP8000 Fibre Channel Adapter
fchan0.15 20-58-0F Emulex LP8000 Fibre Channel Adapter
fchan1.1 20-68-01 Emulex LP8000 Fibre Channel Adapter
fchan1.2 20-68-02 Emulex LP8000 Fibre Channel Adapter
fchan1.3 20-68-03 Emulex LP8000 Fibre Channel Adapter
fchan1.4 20-68-04 Emulex LP8000 Fibre Channel Adapter
fchan1.5 20-68-05 Emulex LP8000 Fibre Channel Adapter
fchan1.6 20-68-06 Emulex LP8000 Fibre Channel Adapter
fchan1.7 20-68-07 Emulex LP8000 Fibre Channel Adapter
fchan1.8 20-68-08 Emulex LP8000 Fibre Channel Adapter
fchan1.9 20-68-09 Emulex LP8000 Fibre Channel Adapter
fchan1.10 20-68-0A Emulex LP8000 Fibre Channel Adapter
fchan1.11 20-68-0B Emulex LP8000 Fibre Channel Adapter
fchan1.12 20-68-0C Emulex LP8000 Fibre Channel Adapter
fchan1.13 20-68-0D Emulex LP8000 Fibre Channel Adapter
fchan1.14 20-68-0E Emulex LP8000 Fibre Channel Adapter
fchan1.15 20-68-0F Emulex LP8000 Fibre Channel Adapter
http://www.ahinc.com/aix/perform.htm
I would appreciate if anybody could give me a pointer to the resolution of
this problem.
Thanks in advance!!!
Shekhar Dhotre
Unix Admin.
Boston, MA-02171.
USA
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:07 EDT