hi courtney is metric extension better than incident rules? better I mean in the sense of easier management, setup I would like to avoid digging the repository views, they are dark, not well documented. I opened a SR a few months back to ask how to query adaptive threshold metrics using the repository views and I got no useful answer from oracle support thanks On Fri, Feb 13, 2015 at 3:38 PM, Courtney Llamas <courtney.llamas@xxxxxxxxxx > wrote: > Yes, you can use Metric Extensions, more specifically Repository side > MEs. This queries the EM repo data (that’s already collected) and then > alerts off that data. > > > http://docs.oracle.com/cd/E24628_01/doc.121/e24473/metric_extension.htm#EMADM10035 > > > The repository side ME help actually gives this example of how to do it: > > > > > > *From:* Ls Cheng [mailto:exriscer@xxxxxxxxx] > *Sent:* Friday, February 13, 2015 3:17 AM > *To:* Ethan Post > *Cc:* Oracle Mailinglist > *Subject:* Re: combining metrics in oem 12c > > > > Oh, no that was a example which took me 15 second to write it down, it > does not make much sense combining logical reads and CPU as you have > suggested. > > The problem I have now is that I have database adaptive threshold on and > it sends quite a lot of mails (may be I set too many metrics) and most > notification are really critical. For example it mails to notify one of the > databases is having 5500 iops, ideally it should notify if the access time > is also high. > > I will look into incident and notification and see if it is doable > cmbining metrics > > Thanks > > > > On Fri, Feb 13, 2015 at 5:57 AM, Ethan Post <post.ethan@xxxxxxxxx> wrote: > > No idea but likely you can write any custom type alert you desire in 12c. > I have written my own system over the years for this sort of thing I can > tell you I have never seen a circumstance in which I want to get out of bed > for such a thing. Don't know what issue your trying to critical alert on > but I am sure I can come up with a better scenario which won't capture > things you don't care about. > > Why logical reads? Why not CPU? For example, if more than 5 sessions have > used more than 75% of a single CPU within the last hour and total available > CPU is < 20% for last 10 minutes, then critical event. Or better yet, send > emails until 6AM, then start paging/open ticket. This usually allows you to > get some much needed sleep but get alerted before most of the folks roll > into work. Or just if total CPU is <20% available for past hour minus the > CPU datapump is burning. You want to alert on the exact issue you are > getting dinged for and still, only get out of bed if it can't wait until 6 > or 7 am. Trust me on this, sleep is awesome and makes for happy employees. > > I have stayed away from EM because by the time I figured out how to write > such an alert in EM terms I usually start wishing I wrote it from scratch. > I know EM has improved a lot so not going to knock it, I am just out of the > loop totally on it, but logical IO is just not a good starting point for an > alert usually, at least one that is going to port well to other databases > (like when CPU's get faster). > > > > > > > > On Thu, Feb 12, 2015 at 5:00 PM, Ls Cheng <exriscer@xxxxxxxxx> wrote: > > Hi > > Does anyone know if it is possible in Enterprise Manager 12c R4 combine > metrics to produce notifications? > > For example if session logical reads metric is 100000 per second and > average active session is larger than 5 then generate a critical event? > > TIA > > > > >