Check Query Performance

How will you check performance of the query, if the query was running earlier but today its taking time to run?

Showing Answers 1 - 4 of 4 Answers


  • Feb 9th, 2017

We can check from AWR report

  Was this answer useful?  Yes


  • Feb 10th, 2017

There are various ways to check performance of query.
1. Use EXPLAIN PLAN if you want to check execution plan used by oracle optimizer to run a query(This is more session specific.)
2. Use AUTOTRACE functionality to check execution statistics of the query.
3. Use EXISTS clause instead of IN clause wherever needed.
4. Use utility such as TKPROF to check total execution plan and staistics of the query.
5. For PLSQL code performance, use DBMS_PROFILER package provided by Oracle.
6. Remove duplicate code in PLSQL.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions