Roads ? - where we're going, we don't need roads ...
Memory Footprint For Dedicated Server Processes More Than Doubled After 11g Upgrade On AIX Platform | ORA600
ORA600 content Content RSS
Oracle ORA600 News RRSS Oracle News RSS
ORA600 blog Blog RSS
ORA600 blog Blog Atom

User login

Memory Footprint For Dedicated Server Processes More Than Doubled After 11g Upgrade On AIX Platform

Another one I categorize under 'I should write this down before I forget'.
Connor Mcdonald - Oracle geek and entertainer extraordinaire - shared this with me last week. Apparently, he was having some memory issues after upgrading to 11gR2 under AIX. As we run 80% of our databases under AIX, I thought I should make a mental note about it (some may call it a blogentry).
For those with metalink access - lookup note id ID 1246995.1 titled 'Memory footprint for dedicated server processes more than doubled after 11g upgrade on AIX platform'.
 

The symptoms are :
  • excessive memory utilization for dedicated server process after upgrade to 11.2.0.1 or 11.2.0.2 on AIX
  • svmon on oracle OS process id shows size of USLA, User-Space Loader Assistant, heap of about 7M bytes
 
 
Example 
svmon -P <PID>
outputs
  • 11.2.0.1.0 -> 7M bytes (=USLA x 4k page size)
  • 11.1.0.7.0 -> 60KB 
  • 10.2.0.4.0 -> 420KB

Example on 11.2.0.1 (unpatched)
 svmon -P 1368120 | grep USLA
 10e811d  9fffffff clnt USLA text,/dev/hd2:8227      s     17     0    -       -
 10d89b9  80020014 work USLA heap                   sm      0     0 1895    1895 ---> x4K = 7Mb
 
Example on 11.2.0.1 (patched)
  c291c2  80020014 work USLA heap                   sm     31     0    0      31 ---> x4K = 124K
 
 
 
This is apparently a bug
Bug 10211065.-P Base Bug 9796810
Abstract: MEMORY FOOTPRINT FOR DEDICATED SERVER PROCESSES MORE THAN DOUBLED AFTER 11G UGP
 
 
Bug 9796810.-P Base Bug 10190759
Abstract: 11G SERVER PROCESSES CONSUMING MUCH MORE MEMORY THAT 10G OR 9I
 
 
Bug 10190759.-P
Abstract:  PROCESSES CONSUMING ADDITIONAL MEMORY DUE TO 'USLA HEAP'

 
 
The good news is - there's a 'interim' patch - number 10190759.
It basically changes the make file so that it excludes certain options (-bexpfull and -brtllib) related to 11g's online patching feature.
It's not really an Oracle problem but it seems related to a bug in runtime loader on AIX.
 
 
Technorati Tags:

Clobetasol 30g With Free Shipping

Wo Kann Ich Viagra Ohne Rezept [url=http://antabuse.ccrpdc.com/buy-cheap-antabuse.php]Buy Cheap Antabuse[/url] Can I Buy Lasix From Canada Cialis Avec Dapoxetine A Vendre Canada [url=http://kamagra.ccrpdc.com/cheap-kamagra-tablets.php]Cheap Kamagra Tablets[/url] Dog Keflex Reaction Amoxicillin Suspension 150ml [url=http://lasix.rxbill7.com/lasix-online-prices.php]Lasix Online Prices[/url] 250 Mg Diamox Buy Paypal Cialis Notice [url=http://zoloft.usamedz.com/cheap-zoloft-no-rx.php]Cheap Zoloft No Rx[/url] Scegliere Levitra On Line Levitra Contraindicaciones [url=http://accutane.mdsmeds.com/buy-accutane-online-usa.php]Buy Accutane Online Usa[/url] Levitra Generika Strips Amoxil Pediatrique [url=http://cialis.ccrpdc.com/cialis-free-offer.php]Cialis Free Offer[/url] Usadirectpharmacy Suhagra Cipla Dangers [url=http://zoloft.usamedz.com/map.php]Zoloft Generic[/url] Betta Fish Amoxicillin Diabetic And Taking Amoxicillin [url=http://propecia.mdsmeds.com/cheap-propecia-5mg.php]Cheap Propecia 5mg[/url] Acheter Sildenafil 50 Mg Amoxicillin Dosage For Cats Capsule [url=http://cytotec.rxbill7.com/misoprostol.php]Misoprostol[/url] Bestellung Viagra Cialis Dailey Drugs From Canada [url=http://prednisone.ccrpdc.com/buy-prednisone-online-now.php]Buy Prednisone Online Now[/url] Propecia Donde Comprar Online Donde Comprar Levitra Generico En Espana [url=http://priligy.rxbill7.com/dapoxetine-tablets.php]Dapoxetine Tablets[/url] Buy Amoxicillin Amazon 252

blanket

study doused this [url=http://onlinecasinos-x.com/]online casinos[/url] where you can win legitimate notes with the avoid of this enchiridionPlaying [url=http://onlinecasinos-x.com/free-casino-bonus.html]no deposit bonus[/url] , buy [url=http://www.sextoysfun.net]sex toys[/url]

Propecia Florida

Donepezil Online Order Acheter Kamagra Cialis Wirkung 20mg [url=http://call4ph.com]viagra[/url] Tinidazole Compro Cialis Online Keflex Antibiotic For Spider Bites [url=http://accutane.inpills.com/where-to-buy-accutane-online.php]Where To Buy Accutane Online[/url] Pyridium Prodium Cleveland Achat Amoxicillin Generique Generic For Cephalexin I Want To Buy Alli! [url=http://cytotec.mdsmeds.com/cheapest-cytotec-online.php]Cheapest Cytotec Online[/url] Fedex Shipping Amoxicilina Website Express Delivery Aberdeenshire Buy Amoxicillin For Pet [url=http://xenical.mdsmeds.com/order-xenical-online.php]Order Xenical Online[/url] Precio Cialis 10 Occipital Baldness Propecia Cheap Amitriptyline [url=http://clomid.inpills.com/where-to-buy-clomid.php]Where To Buy Clomid[/url] Achat Propecia Canada

11.2.0.2


Hi, is this fixed in 11.2.0.2 ?
 
Thx. 

Patch exists for 11.2.0.2

Hi d,

there exists a patch (#10190759) for 11.2.0.2 so it's not fixed in the base release.

regards

Friedrich




Howto's
See DUDE primer for info

Get Support

Europe

Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714

Denmark :
Michael Môller
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 74 71 27


Latin America

Brazil :
HBtec
E-mail
dude@hbtec.com.br
Cell : +55 47 88497639
Contact


Africa

South Africa :
Kugendran Naidoo
NRG Consulting
E-mail
k@nrgc.co.za
Cell : +27 82 7799275