Showing posts with label oem. Show all posts
Showing posts with label oem. Show all posts

Thursday, November 12, 2009

Real Time SQL Monitoring


here is a feature that I'm excited about:
Real Time SQL Monitoring
Active Session History has added fields that can track the execution id of a statement as well as the row source (ie line in the explain plan) that the query is executing. For long running queries this can be a way to see where the query is at as well as seeing which row sources are more expensive and for short running queries one can build up a statistical picture of what row sources are expensive.
11g ASH has added the fields

SQL_EXEC_ID

SQL_EXEC_START

that can track and distinguish different executions of the same sql.

11g ASH has added the fields

SQL_PLAN_LINE_ID

SQL_PLAN_OPERATION

SQL_PLAN_OPTIONS

That can track the particular line in the execution plan that is executing

Tuesday, November 10, 2009

Oracle EM Desktop Widgets

Oracle add desktop widgets to OEM. Wonder if this is targeted for mobile devices or not?