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
Comments