Oracle VP Leng Leng Tan 
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: 
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 
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.
=,-)
January 11, 2008 at 8:23 am |
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