oracle probe parameter default values and units

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

I want to configure 'memory_usage’, ‘sga_memory’, and ‘sga_memory_free’ parameters from the oracle probe but I'm not able to understand their threshold value units and what does that mean for example if some numerical value is given by default, e.g., 2000, under memory usage then what this stands for and same for sga memory & sga memory free. Could you please help here and also provide the default threshold values for these parameters.

Environment

Release : 9.0.2

Component : UIM - ORACLE

Resolution

Please refer to the oracle help doc metrics page to see the units for each metric. 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-metrics.html

The threshold defaults for each metric will be in the oracle.cfx (default configuration file).

For example, under each metric in the oracle.cfx, you'll see the sections:

<thresholds>
         <default>
            <0>
               value = 1
               msg = sga_memory_1
               sev = information
            </0>
         </default>
      </thresholds>

For alarms, the default settings are listed in the doc under Alert Metrics Default Settings.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-metrics.html#concept.dita_f34f1d74af4bfbb2f30c2a1e8813c745b95370c8_AlertMetricsDefaultSettings

The default threshold values for those 3 metrics are as follows:

memory_usage (Bytes)
Monitors the memory consumption in bytes of Oracle users (PGA).
default threshold: 2000000

sga_memory (Bytes)
Measures the SGA memory usage in bytes by pool.
default threshold: 1

sga_memory_free (Bytes)
Measures the SGA free memory usage in bytes
default threshold: 4096