I came across this basic Oracle Explain Plan fundamental tutorial on Youtube. The explain plan is the basic knowledge that the developers and DBAs may consider getting to understand.
The presenter in this video tutorial gave the theory and then went through the explain plan demonstration. What were presented in this tutorial were:
- Understand of Basic Explain Plan.
- How to setup Oracle Explain Plan and how to use it.
- Understand the Explain PLAN_TABLE, DBMS_XPLAN.DISPLAY
- How to generate and View Explain Plan
- How to read and interpret basic Explain Plan
- What is the limitation of the Explain Plan
Enjoy your watch.
0 comments:
Post a Comment