Video: Explain Plan, Execution Plan, AutoTrace, and Real Time SQL Monitoring

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

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.

    Related Posts

    Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *