top of page
  • Writer's picturekyle Hailey

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



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

11g ASH has added the fields




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

18 views0 comments

Recent Posts

See All


bottom of page