Oracle DBA – A lifelong learning experience

Posts Tagged ‘OMI’

How to add a metric extension and use a ‘control’ table to test results

Posted by John Hallas on November 27, 2017

I have previously blogged about creating a User Defined Metric (UDM) before  (7 years ago!)  but the method I am using today demonstrates how you can test out the alert using specific data.

The aim was to see if integration data is flowing through a table.  If there is a backlog we want to know about it.

Simon Ryan, a colleague did all the preparatory work and created all the 18 !! screen shots which I had to copy and paste into this entry

select * from sm7.EVENTOUTM1; -- Transient table so data not usually present.

The data is processed quickly but occasionally you can see a handful of rows for a few seconds.

select DESCRIPTOR ,
EVTYPE ,
TO_CHAR(EVTIME, 'DD-MON-YYYY HH24:MI:SS') ,
EVSYSSEQ ,
EVUSRSEQ from sm7.EVENTOUTM1;
DESCRIPTOR EVTYPE EVTIME EVSYSSEQ EVUSRSEQ
 (BLOB) email 08-NOV-2017 11:40:01 0000000005254328

A typical query for the ME would be very simple:

select count(*) from sm7.EVENTOUTM1;

However, we are going to plugin a ‘control’ table in order for us to test the alert by artificially adjusting the results. Read the rest of this entry »

Advertisements

Posted in Oracle | Tagged: , , , | Leave a Comment »