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