We use cookies to ensure that we give you the best experience on our website.  Visit our Privacy Policy to learn more. If you continue to use this site, we will assume that you are okay with it.

Your choices regarding cookies on this site.
Your preferences have been updated.
In order for the changes to take effect completely please clear your browser cookies and cache. Then reload the page.

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

ComponentChecks & Agents
Titleoracle_performance: Optionally new statistics for IO and system wait
Date2020-10-22 10:47:33
Checkmk EditionCheckmk Raw Edition (CRE)
Checkmk Version2.0.0i1
LevelTrivial Change
ClassNew Feature
CompatibilityIncompatible - 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:

  • oracle_performance.iostat_ios: IO statistics displayed as raw IOs.
  • oracle_performance.iostat_bytes: IO statistics displayed in bytes.
  • 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.