Re: OEM email alert for Tablespace Usage

From: ed lewis <eglewis71_at_gmail.com>
Date: Fri, 25 Feb 2011 10:42:43 -0500
Message-ID: <2E58419518744E3EA841C10031964721_at_CATHY>

I didn't create the rule. It's one of the oracle supplied rules called "Database Availability and Critical States". Within there is "blocked session count". And Yes, I have subscribed to the rule I mentioned above.

• Original Message ----- From: Niall Litchfield To: eglewis71_at_gmail.com Cc: merchanti_at_hotmail.com ; cicciuxdba_at_gmail.com ; sundarmahadevan82_at_gmail.com ; oracle-l_at_freelists.org Sent: Friday, February 25, 2011 9:16 AM Subject: Re: OEM email alert for Tablespace Usage

  Have you subscribed to the notification rule you created for the alert?

  On Fri, Feb 25, 2011 at 1:42 PM, ed lewis <eglewis71_at_gmail.com> wrote:

    Hi,

        I'm having a similiar problem.
    I have email alerts set up, and a get alter notifications     mailed to me in most cases.

        For "blocked session count", an alert is generated,     but it is not mailed to me. Any idea what that might be ?

        thanks

• Original Message ----- From: Imtiaz Merchant To: cicciuxdba_at_gmail.com ; sundarmahadevan82_at_gmail.com Cc: oracle-l_at_freelists.org Sent: Thursday, February 24, 2011 10:27 PM Subject: RE: OEM email alert for Tablespace Usage

      Sundar,

      There are some very annoying differences between EM Grid Control 10g and 11g. I had the same issues when I upgraded from 10g GC to 11g GC myself.

        1.. Navigate to the target home page and, under Related Links, click Metric and Policy Settings. 
        2.. Here you will find the Metric Thresholds and Policies tabs where you can edit the thresholds. 


      Assuming you are looking to define thresholds for a Monitoring Template (which could be applied to more than one target at the same time) 


        1.. Click on the Preferences link at the top right of the EM Grid Control Screen 
        2.. Click on the Monitoring Configuration option in the Left Navigation pane  
        3.. Depending on whether you already have a template or are defining a new one, choose an existing template and hit edit or create a new one 
        4.. Once in the monitoring template, you can now define thresholds for the template.  Click on the pencil icon at the far right to modify.


      Hope that helps you do what you were looking for. 


      - Imtiaz





--------------------------------------------------------------------------

      Date: Thu, 24 Feb 2011 21:03:27 -0300
      Subject: Re: OEM email alert for Tablespace Usage
      From: cicciuxdba_at_gmail.com
      To: sundarmahadevan82_at_gmail.com
      CC: Oracle-L_at_freelists.org

      You can either define a template, which affects all the targets of a group or you can define a special value from the Policy link in performance page of the target. (I might have the name wrong, but it was something to do with policies and it was on the performance page in related links if I recall...)

      hth
      Alan.-



      On Thu, Feb 24, 2011 at 6:53 PM, sundar mahadevan <sundarmahadevan82_at_gmail.com> wrote:

        Hi Group,
        Greetings. I am trying to setup OEM email alert when the tablespace reaches 85% for warning and 95% for critical. I go to preferences -> under Notification -> Rules -> create a rule -> for All targets of type Database Instance -> and the metric is Tablespace Space Used . I do not see any threshold specified (remember seeing thresholds specified). Am I doing it right? My OEM grid is 11.1. Dint get much help from google and metalink. Thanks in advance.

  --
  Niall Litchfield
  Oracle DBA
  http://www.orawin.info

--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 25 2011 - 09:42:43 CST