5 Replies Latest reply: Feb 28, 2013 7:11 AM by Arturo Gutierrez RSS

    Thresholds on modified RAC metrics are not evaluated : EM 12 Cloud

    Arturo Gutierrez
      Hello,

      I have a problem changing the values assigned to the RAC performance metrics using monitoring templates.

      I've defined a custom template Database Instance level thresholds for amending certain metrics RAC. But it seems that these changes are being realizing. But that I keep getting notifications whose values are below the new thresholds defined.

      example:
      Notification:
      EM Event: Warning: COLLDESK_COLLDESK2 - Metrics "Global Cache Average Current Get Time" is at 1

      While the metric values are defined as follows:
      Global Cache Average Current Block Request Time (centi-seconds)

      Warning Threshold     1.2
      Critical Threshold     3
      Comparison Operator     >
      Occurrences Before Alert     3
      Corrective Actions     None

      If I go to metrics at this target level.
      I see that the metric has the change values at template level.

      Thresholds last modified by     Template backup_Database_Instance was applied by A_GUTIERREZ on Feb 24, 2013 10:52:33 PM CET.

      The template was applied to a group compound several RAC databases.

      Any has any idea about this issue and how to fix?
      Many Thanks
      Arturo
        • 1. Re: Thresholds on modified RAC metrics are not evaluated : EM 12 Cloud
          user735250
          Arturo,

          What is the rac database version? You are referring to two different metrics in your example - "Current Get Time" and "Current Bloack Request Time". Can you verify thresholds for the metric you got alert and if that seems incorrect (please upload the metric values and alert text). Also, can you run query "select * from dba_thresholds" from rac instance where you received incorrect alert and upload it.

          Thanks,
          Ravi
          • 2. Re: Thresholds on modified RAC metrics are not evaluated : EM 12 Cloud
            Arturo Gutierrez
            Hello Ravi,
            This is a 10.2.0.4 (4nodes) Rac on Linux.

            This a alert text:

            Host=WEUSRV011.intrum.net
            Target type=Database Instance
            Target name=ie_colldesk_iecolld1
            Categories=Performance
            Message=Metrics "Global Cache Average Current Get Time" is at 0.615
            Severity=Warning
            Event reported time=Feb 25, 2013 9:44:05 PM CET
            Target Lifecycle Status=Production
            Comment=WEU Oracle Production Hardware
            Operating System=Linux
            Platform=x86_64
            Event Type=Metric Alert
            Event name=rac_global_cache:currentgets_cs
            Metric Group=Global Cache Statistics
            Metric=Global Cache Average Current Block Request Time (centi-seconds)
            Metric value=0.615384615384615
            Key Value=SYSTEM
            Rule Name=Locks_Rule,rule 96
            Rule Owner=A_GUTIERREZ
            Update Details:
            Metrics "Global Cache Average Current Get Time" is at 0.615

            And
            Host=tstcolldesk01.intrum.net
            Target type=Database Instance
            Target name=COLLDESK_COLLDESK1
            Categories=Performance
            Message=Metrics "Global Cache Average Current Get Time" is at 0.632
            Severity=Warning
            Event reported time=Feb 25, 2013 9:03:00 PM CET
            Comment=WEU Oracle test Environment
            Operating System=Linux
            Platform=x86_64
            Event Type=Metric Alert
            Event name=rac_global_cache:currentgets_cs
            Metric Group=Global Cache Statistics
            Metric=Global Cache Average Current Block Request Time (centi-seconds)
            Metric value=0.631578947368421
            Key Value=SYSTEM
            Rule Name=Locks_Rule,rule 96
            Rule Owner=A_GUTIERREZ
            Update Details:
            Metrics "Global Cache Average Current Get Time" is at 0.632


            The metrics definition is:
            Global Cache Average Current Block Request Time (centi-seconds)
            Global Cache Average CR Block Request Time (centi-seconds)
            And the metrics values defined at template level are:

            Warning Threshold 1.2
            Critical Threshold 3
            Comparison Operator >
            Occurrences Before Alert 3
            Corrective Actions None

            I need to explore select * from dba_thresholds.

            Thanks
            Best regards
            Arturo
            • 3. Re: Thresholds on modified RAC metrics are not evaluated : EM 12 Cloud
              Arturo Gutierrez
              Hello Ravi,
              Seems like this metrics come from the Oracle Server not Cloud console.
              Doing the query to:

              select METRICS_NAME,WARNING_VALUE,CRITICAL_VALUE,CONSECUTIVE_OCCURRENCES,INSTANCE_NAME,STATUS
              22 from dba_thresholds
              23* order by metrics_name;
              METRICS_NAME WARNING_VA CRITICAL_V CONSECUTIVE_OCCURRENCES INSTANCE_NAME STATUS
              ---------------------------------------- ---------- ---------- ----------------------- ---------------- -------
              Global Cache Average CR Get Time 0.5 1 1 spcolld1 VALID
              Global Cache Average CR Get Time 0.5 1 1 spcolld2 VALID
              Global Cache Average CR Get Time 0.5 1 1 spcolld3 VALID
              Global Cache Average CR Get Time 0.5 1 1 spcolld4 VALID
              Global Cache Average Current Get Time 0.5 1 1 spcolld1 VALID
              Global Cache Average Current Get Time 0.5 1 1 spcolld3 VALID
              Global Cache Average Current Get Time 0.5 1 1 spcolld2 VALID
              Global Cache Average Current Get Time 0.5 1 1 spcolld4 VALID

              Then I need to use other method to modify this thresholds.

              Any advise?
              Thanks
              Arturo
              • 4. Re: Thresholds on modified RAC metrics are not evaluated : EM 12 Cloud
                user735250
                Arturo,

                Modify thresholds from EM and the threshold changes will be updated to dba_thresholds (both EM and dba_thresholds will be in sync).

                Regards,
                Ravi
                • 5. Re: Thresholds on modified RAC metrics are not evaluated : EM 12 Cloud
                  Arturo Gutierrez
                  Hi Ravi,
                  Finally I've use the DBMS_ALERT to change the metrics values at Database level. And the number of emails has been reduced.
                  Thanks for give support in this issue.

                  I miss more clarity on this issue. Since this read well Cloud metrics messages BD itself. But I should be more clear in the notification messages to clarify and direct the DBA to change the specific area where the thresholds.
                  I have not read any document that talks about this option. Neither of good practice when defining alerts.
                  Anyway thanks for the help.
                  I learned a lot!
                  Best regards
                  Arturo