Re: Looking for Installation Guide and Best Practices with Oracle + WLM on AIX

Good information, thank you.

Do you know how the WLM acts?

a) Is it "thinning out" the CPU schedule, thus the restricted process needs to wait longer for its CPU slot, 
b) or does it throttle the CPU speed for the process? 
c) anything else? 

Background of my question is: Whenever we start lying to Oracle about CPU usage ("CPU seems to compute, but in fact does not"), all CPU-related metrics and calculations are vanity. My personal trauma in this context is Buffer Gets: On bare metal w/o any CPU restrictions, you have a more or less constant BG per CPU time relation (if the workload is constant). If you start shifting this equation in a non-predictable way (by outside CPU priority shifting), doing performance diagnosis becomes a nightmare.

Stay safe

-- 
Martin Klier // Performing Databases GmbH 
Managing Partner // Senior DB Consultant 
Oracle ACE Director 

martin.klier_at_performing-db.com // https://www.performing-databases.com 



> Von: "Markus Zwettler" <Markus.Zwettler_at_zuerich.ch>

> An: "Martin Klier" <martin.klier_at_performing-db.com>

> CC: "Oracle-L Freelists" <oracle-l_at_freelists.org>


> Gesendet: Donnerstag, 7. November 2019 15:05:58

> Betreff: AW: Looking for Installation Guide and Best Practices with Oracle + WLM

> on AIX




> Afaik,





> … Workload Manager (WLM) is fully transparent to Oracle and therefore supported





> … Workload Partitions (WPAR) are not fully transparent to Oracle and therefore


> only supported as "system workload partition"




> Cheers, Markus





> Von: Martin Klier - Performing Databases GmbH <martin.klier_at_performing-db.com>


> Gesendet: Donnerstag, 7. November 2019 10:48

> An: Zwettler Markus (OIZ) <Markus.Zwettler_at_zuerich.ch>

> Cc: Oracle-L Freelists <oracle-l_at_freelists.org>

> Betreff: Re: Looking for Installation Guide and Best Practices with Oracle + WLM

> on AIX




> Hi Markus,





> this rings a bell somewhere - are you sure that "external" workload managers are


> supported w/ Oracle at all?




> My last experience with "transparent" resource management on hypervisor or OS


> level was not so exciting... but a good lesson learned: switch it off as much

> as possible.




> Cheers





> --

> Martin Klier // Performing Databases GmbH


> Managing Partner // Senior DB Consultant

> Oracle ACE Director




> [ mailto:martin.klier_at_performing-db.com | martin.klier_at_performing-db.com ] // [


> https://www.performing-databases.com/ | https://www.performing-databases.com ]



>> Von: "Zwettler Markus (OIZ)" < [ mailto:Markus.Zwettler_at_zuerich.ch |
>> Markus.Zwettler_at_zuerich.ch ] >
>> An: "Oracle-L Freelists" < [ mailto:oracle-l_at_freelists.org |
>> oracle-l_at_freelists.org ] >
>> Gesendet: Mittwoch, 6. November 2019 12:26:15
>> Betreff: Looking for Installation Guide and Best Practices with Oracle + WLM on
>> AIX
>> Hi,

>> We are consolidating multiple Oracle databases to a few IBM PowerVM LPAR's.

>> We want to do resource management using AIX Workload Manager (WLM).

>> Does anyone have an installation guide or best practices using WLM with Oracle
>> databases?

>> Thanks,

>> Markus

--
http://www.freelists.org/webpage/oracle-l