AW: Looking for Installation Guide and Best Practices with Oracle + WLM on AIX
Date: Thu, 7 Nov 2019 15:33:55 +0000
Message-ID: <bcd2faa3dbe5442fa59fcbf605c0d57e_at_zuerich.ch>
Afaik, WLM influences the CPU scheduler lowering the priority of or even freezing large consumer processes.
We don't have constant cpu resources as we are using uncapped LPAR's with CPU pools (license costs). So the performance diag problem appears anyway. ;-)
Cheers, Markus
Von: Martin Klier - Performing Databases GmbH <martin.klier_at_performing-db.com> Gesendet: Donnerstag, 7. November 2019 15:20 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
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<mailto:martin.klier_at_performing-db.com> // https://www.performing-databases.com
Von: "Markus Zwettler" <Markus.Zwettler_at_zuerich.ch<mailto:Markus.Zwettler_at_zuerich.ch>> An: "Martin Klier" <martin.klier_at_performing-db.com<mailto:martin.klier_at_performing-db.com>> CC: "Oracle-L Freelists" <oracle-l_at_freelists.org<mailto: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<mailto:martin.klier_at_performing-db.com>> Gesendet: Donnerstag, 7. November 2019 10:48 An: Zwettler Markus (OIZ) <Markus.Zwettler_at_zuerich.ch<mailto:Markus.Zwettler_at_zuerich.ch>> Cc: Oracle-L Freelists <oracle-l_at_freelists.org<mailto: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
martin.klier_at_performing-db.com<mailto:martin.klier_at_performing-db.com> // https://www.performing-databases.com
Von: "Zwettler Markus (OIZ)" <Markus.Zwettler_at_zuerich.ch<mailto:Markus.Zwettler_at_zuerich.ch>> An: "Oracle-L Freelists" <oracle-l_at_freelists.org<mailto: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
Received on Thu Nov 07 2019 - 16:33:55 CET