1 Reply Latest reply: Feb 4, 2013 11:39 PM by OraFighter RSS

    Tuning related query

    Aryacool
      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.

      Thanks
      Arya
        • 1. Re: Tuning related query
          OraFighter
          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.