APEX and OEM data…a match made in heaven!

I’ve always been a BIG fan of Oracle Enterprise Manager, especially the information that can be extracted from the repository.

Since version 11, the information has been used to produce a variety of custom reports using either Information Publisher and later the integrated BI Publisher component. The immense value of the information available in the repository database cannot be quantified, but the representation of the information has (In my opinion) on occasion fallen flat. I’ve casually toyed with APEX before, but it wasn’t until I came across this tweet from Joel Kallman that I decided to pickup the gauntlet once more. About two weeks later and I was on my way!

With the foundation in place, I started putting together the first part of my overall plan…and that was to create a dashboard that would at a glance provide the operational teams with the ability to pro-actively take action against items which most often result in after hours call-outs and unwanted visits to the proverbial red carpet!

Now I’ll be the first to admit that my skills as a UX designer are virtually non-existent 🙂 With that in mind, what I did want to do is to make use of a colour scheme similar to that employed by traffic lights, i.e. green means “All clear”, amber/orange means “Have a look” and red means “s***s going to hit the fan”! I also found that there’s a great APEX community and I came across a plugin provided by Roel Hartman to give my dashboard a bit of an OEM-esque feel.

After about two weeks of using the dashboard (As at the time of writing this blog), the overall counts have come down significantly!

I’m looking forward to seeing how else OEM data can be visualized going forward, needless to say I’ll be putting out more information in this regard in due course


P.S. On the Oracle Developer Community, there are varied opinions in terms of what should be monitored/reported on and what I’ve indicated above is by no means the “be all and end all” list…it’s what we as a team have found to be key elements to be aware of. I’d really like to hear what others may feel is important to keep in check, so please add your comments below.

Leave a Comment