Werk #11375: oracle_performance: Optionally new statistics for IO and system wait

Component Checks & agents
Title oracle_performance: Optionally new statistics for IO and system wait
Date Oct 22, 2020
Checkmk Edition Checkmk Raw (CRE)
Checkmk Version 2.0.0i1
Level Trivial Change
Class New Feature
Compatibility Incompatible - Manual interaction might be required

With this change, new statistics for IO and system waits are added optionally. These statistics need to be activated through the rule "Oracle performance discovery". They are not automatically available since the activation of these statistics may produce a lot of additional metric data. So this data will created only, if you decide so.

To use the feature, you need to replace the agent plugin with the newest version and activate the new services through the mentioned ruleset above. You will be able to add up to three new services:

LI:oracle_performance.iostat_ios: IO statistics displayed as raw IOs. LI:oracle_performance.iostat_bytes: IO statistics displayed in bytes. LI:oracle_performance.waitclasses: Details about the reasons the DB spends time waiting.

Important: As fetching statistics about IOs may take a long time in some configurations, these data is fetched through the agent plugin asynchronously by default with section name iostats. If you change this section to synchronously, which is recommended in most cases, please check if you are able to optimize you indexing if needed to avoid such problems.

To the list of all Werks