Operation



The database administrator follows a step by step approach to troubleshoot the query slowdown problems.


The three TE views on the right pane display the required information to troubleshoot the query slowdown problem using the above steps. The views are :


Before you begin troubleshooting, complete the below steps :


Step 1 : Turn on refresh for 5 seconds. Find the option for refresh on the right end of the top right pane.
Step 2 : Set the 'number of rows returned' for the adhoc sql to 20000. Find the option for setting the rows returned under 'options' tab in the adhoc sql window.
Step 3 : Note the elements to be monitored mentioned in section 'Highlights'.
Step 4 : Execute the SQL in the adhoc sql window. To do so, click on 'run' button in the adhoc sql window.

Note: The SQL query in the adhoc SQL window, is designed to run for long duration. If query takes long, reduce the number of tables involved in the join and remove the corresponding join from the query.

Highlights