Open the performance page of a database, here in the Average Active Session chart, click on the CPU block on the chart of its corresponding wait class. The Active Sessions Working page appears. And when we click on the dark area which is pointed out here with arrow, then we can see the 'Detail for select 5 minute interval' page. Here we can see the 'Top Working SQL' table.
When we click on the SQL ID link of the most active SQL statement in the Top Working SQL table. The SQL Details page appears.
For SQL statements that are using the majority of the wait time, use SQL Tuning Advisor or create a SQL Tuning Set to tune the problematic SQL statements.
When we click on the SQL ID link of the most active SQL statement in the Top Working SQL table. The SQL Details page appears.
For SQL statements that are using the majority of the wait time, use SQL Tuning Advisor or create a SQL Tuning Set to tune the problematic SQL statements.
No comments:
Post a Comment