How to Generate an Execution Plan in Oracle

Although there are a number of tools that will display an Oracle Execution Plan for you, there really are only two ways to generate the plan. You can use the Explain Plan command or you can view the plan of a SQL statement currently in the Cursor Cache using the dictionary view V$SQL_Plan. This video gives you a brief but detailed description of both approaches. It also explains when to use each approach to your best advantage. TOC What is the difference between Explain Plan and V$SQL_PLAN 0:43 How to use the Explain Plan command in Oracle 1:35 How to use v$SQL_PLAN 2:41 How to use the Format parameter of DBMS_XPLAN? 4:00