1 Reply Latest reply on Feb 5, 2013 5:39 AM by OraFighter

    Tuning related query

      Hi Friends,

      I have a doubt on performance issue..

      When we have to use dbms_xplan or explain plan for tuning purpose
      and when we have to use dbms_sqltune adviser.

      for a poor performing sql. Or approach to solve database performance issue.

        • 1. Re: Tuning related query
          Explain plan is for checking each sql query How it has executed.. which plan it is used. we can check each query execution plan using Explain plan. after that we need to intrepret it wheather it is ok or not.

          Sqltuning advisor automatically gives you some advices based on the sqls run on your database. you will get it from Enterprise manager.