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

From: <fmhabash@xxxxxxxxx>
To: Courtney Llamas <courtney.llamas@xxxxxxxxxx>, Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx>
Date: Wed, 24 Feb 2016 13:41:13 -0500

I understand, but include them disabled. This way, users need not engineer
monitors that can be simply set via a checkbox. This specially true for events
that we know are impactful to database performance such as mutex and latch
contention.

Connsider this a feature request 😊

----------------------------------------
Thanks

From: Courtney Llamas
Sent: Wednesday, February 24, 2016 1:36 PM
To: fmhabash@xxxxxxxxx; Kellyn Pot'Vin-Gorman
Cc: Oracle-L Group
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

Courtney Llamas | Consulting Member of Technical Staff
Phone: +2814108258 | Mobile: +8324720596
Oracle Strategic Customer Program

Oracle

Oracle is committed to developing practices and products that help protect the
environment
From: fmhabash@xxxxxxxxx [mailto:fmhabash@xxxxxxxxx] ;
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
Sent: Wednesday, February 24, 2016 1:24 PM
To: fmhabash@xxxxxxxxx
Cc: Oracle-L Group
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

Kellyn Pot'Vin-Gorman
about.me/dbakevlar

On Wed, Feb 24, 2016 at 11:02 AM, <fmhabash@xxxxxxxxx> 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

References:
- How to Monitor Wait Event Average Elapsed Time Using EMCC12c
  - From: fmhabash
- Re: How to Monitor Wait Event Average Elapsed Time Using EMCC12c
  - From: Kellyn Pot'Vin-Gorman
- RE: How to Monitor Wait Event Average Elapsed Time Using EMCC12c
  - From: fmhabash
- RE: How to Monitor Wait Event Average Elapsed Time Using EMCC12c
  - From: Courtney Llamas

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

Other related posts: