15 minutes overview of how to use these features in Oracle SQL Developer:

  • Get an Explain Plan
  • Customize the display of the plan
  • Get a cached plan
  • Use DBMS_XPLAN
  • Compare Plans
  • Use Real Time SQL Monitoring
  • Use AutoTrace.
  • And if you want an awesome video, MUCH more in depth about how to read a plan, then I suggest this from @sqlmaria.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Write A Comment