Sql Tuning Tools to display execution plans

 

Tools used to display execution plans

• Explain Plans
  • SQL Statements enable you to view the execution plan that the optimizer would use to executed a SQL Statement without actually executing the statement
• AutoTrace
  • the AuthTracce command in SQL *Plus, generate the execution plan and statistics about the performance of the query. This commands provide statistics such as disk reads and memore leaks
• V$SQL Plan
  • These view contains information about executed SQL statements, their execution plans that are still in shared pool
  • Use DBMS_XPLAN package methods to display the execution plan generated by the EXPLAIN_PLAN command and query of V$SQL_PLAN