Re: How to Monitor Wait Event Average Elapsed Time Using EMCC12c

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
Date: Wed, 24 Feb 2016 12:09:24 -0700
Message-ID: <CAN6wuX1hKRYbbY-b9VF85nUO5NqYG8yrcCo1cu3p6im_dyYLVg_at_mail.gmail.com>

The Enterprise Manager product is a self-service product. There are a ton of features and products that Oracle works very hard to keep as "light" as possible. The important monitoring features may differ drastically from one customer to another. What may be a top ten for you, even if it were to be disabled, may be far down on the list for another customer, so we've ensured that you have the functionality available to ensure you can monitor almost anything imaginable.

Hope this helps,
Kellyn Pot'Vin-Gorman
Consulting Member of Technical Staff, SCP Oracle

[image: Kellyn Pot'Vin on about.me]

Kellyn Pot'Vin-Gorman
about.me/dbakevlar
  <http://about.me/dbakevlar>

On Wed, Feb 24, 2016 at 12:02 PM, <fmhabash_at_gmail.com> wrote:

> Since it is not default, how are you handling scenarios where your
> database latch/mutex contention goes 2000% at 150 ms proactively?
>
>
>
> Even though possible to do through home-grown scripts, but if adaptive
> monitors are suited the most for anything, it is for wait event monitoring.
> Having to engineer such adaptive feature is not something clients are
> willing to pay for.
>
>
>
> Do you rely on v$system_event/v$session_event?
>
>
>
> ----------------------------------------
> Thanks
>
>
>
> *From: *Courtney Llamas <courtney.llamas_at_oracle.com>
> *Sent: *Wednesday, February 24, 2016 1:36 PM
> *To: *fmhabash_at_gmail.com; Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
>
> *Cc: *Oracle-L Group <oracle-l_at_freelists.org>
> *Subject: *RE: How to Monitor Wait Event Average Elapsed Time Using
> EMCC12c
>
>
>
> You can see the available metrics in the DB Reference guide -
> http://docs.oracle.com/cd/E24628_01/em.121/e25160/oracle_database.htm#EMDBM3179.
> These correspond to the DB wait event classes
> http://docs.oracle.com/cd/E11882_01/server.112/e40402/waitevents001.htm#BGGHJGII
>
>
>
> Setting thresholds on each specific wait would be very time consuming and
> error prone when new versions/waits are introduced.
>
>
>
> --
> - Courtney
>
> [image: Oracle] <http://www.oracle.com/>
> Courtney Llamas | Consulting Member of Technical Staff
> Phone: +2814108258 | Mobile: +8324720596
> Oracle Strategic Customer Program
>
> Oracle
>
> [image: Green Oracle] <http://www.oracle.com/commitment>
>
> Oracle is committed to developing practices and products that help protect
> the environment
>
>
>
> *From:* fmhabash_at_gmail.com [mailto:fmhabash_at_gmail.com]
> *Sent:* Wednesday, February 24, 2016 12:27 PM
> *To:* Kellyn Pot'Vin-Gorman
> *Cc:* Oracle-L Group
> *Subject:* RE: How to Monitor Wait Event Average Elapsed Time Using
> EMCC12c
>
>
>
> I’m a bit surprised why did Oracle not include such metrics in the default
> template, even if disabled.
>
>
>
> ----------------------------------------
> Thanks
>
>
>
> *From: *Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
> *Sent: *Wednesday, February 24, 2016 1:24 PM
> *To: *fmhabash_at_gmail.com
> *Cc: *Oracle-L Group <oracle-l_at_freelists.org>
> *Subject: *Re: How to Monitor Wait Event Average Elapsed Time Using
> EMCC12c
>
>
>
> By the data you've provided, elapsed time per a specific wait event isn't
> a default metric, but yes, you could easily create this with a metric
> extension. Once you add it to a target, then use that target as the base
> for a template and then you can use it elsewhere.
>
>
>
> Hope this helps,
>
> Kellyn
>
>
>
>
> [image: Kellyn Pot'Vin on about.me]
>
>
>
> *Kellyn Pot'Vin-Gorman*
>
> about.me/dbakevlar
>
>
>
>
>
> On Wed, Feb 24, 2016 at 11:02 AM, <fmhabash_at_gmail.com> wrote:
>
> I had a need to create EM monitors/alerts when a particular wait event
> average elapsed time exceeds a threshold. Looking at the default template,
> I see wait classes (by waiter count) and no wait event metrics.
>
>
>
> Are wait event metrics not available in anywhere in a template?
>
> Do I have to create a metric extension for this purpose?
>
>
>
> ----------------------------------------
> Thanks
>
>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 24 2016 - 20:09:24 CET