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

[@michaelkclark6981]

Great Job as usual. ( this is my person account - I am Michael Clark from Oracle )

[@zhongzhengmou8910]

Thanks maria , very nice lesson

[@techcraftarena1305]

Thanks a lot 👍

[@redwisdome]

Thank you Maria

[@ramchinthakayala2092]

Please tell us about why we need to gather stats?

[@sourabhpatel2391]

to optimize performance and for compliance issues in corporates

[@sourabhpatel2391]

are you the creator of mariadb?

[@SQLMaria]

No, I'm not. But I do share the same name as the creator's daughter, who he named the database after.