Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

In this video I describe how you can use Oracle's DBMS_XPLAN.DISPLAY_CURSOR to examine the execution plan for a SQL statement that has recently been executed and determine if that plan is optimal or not and where you might be able to optimize it.

• #science_technology
• #dbms_xplandisplay_cursor
• #oracle_database
• #execution_plans
• #query_tuning
• #query_plans
• #oracle
• #database
• #dbms_xplan
• #explain_plan
• #query
• #tuning
• #sql
• #plan
• #execution
• #sql_tuning