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


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

24 views0 comments

Recent Posts

See All

Comments


bottom of page