From: Dhotre, Shekhar (Shekhar.Dhotre@T-T.COM)
Date: Thu Aug 08 2002 - 10:52:41 EDT
>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