Realtime SQL Monitoring with Enterprise Manager 11g

Oracle VP Leng Leng Tan lang_lang.jpg and two members of her team presented some highlights of the new OEM which is at the beta level at present. You can find details  for her OOW presentations and demos and other sources here.

I want to share two of them:  sql_monitor_01.jpg The first is SQL Real Time Monitoring:
With OEM 11g it is possible to monitor every sql statement in real time while it is running.

 We will soon have a graphical interface which we can use to monitor sql statements while they are running and can drill down into the statement’s steps sql_monitor_021.jpg sql_monitor_03.jpg sql_monitor_04.jpg sql_monitor_05.jpg 

  and see which step takes how much DB-TIME and what does it consume: is it CPU is it I/O and so forth. This makes it very easy to find out which step needs tuning exactly. In the demo yesterday they executed a long runnig parallel select and showed how easy it is to find out which full table scan need tuning in order to improve the performance of teh entire statement.

This is a very cool feature!

My next post will be about Data masking for testing.
=,-)

This entry was posted on Tuesday, November 13th, 2007 at 5:53 pm and is filed under Oracle 11g features posts, Oracle Open World 2007. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Realtime SQL Monitoring with Enterprise Manager 11g”

  1. Karl Says:
    January 11, 2008 at 8:23 am | Reply

    Hi,
    indeed very interesting. It’s hard even with an execution plan to determine which step caused the largest comsumption of resources. The estimations in the plan are very often not solid.
    Does this feature works with dbconsole 11g too or only with the Grid Control?
    Karl

Leave a Reply