Grow your YouTube channel like a PRO with a free tool

Get Free YouTube Subscribers, Views and Likes

Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

Follow

Maria Colgan (SQLMaria)

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.

posted by lepenofq

How to Generate an Execution Plan in Oracle

How to Generate an Execution Plan in Oracle

Oracle Performance Tuning Read and interpret Explain Plan

Oracle Performance Tuning Read and interpret Explain Plan

How to read a Parallel Execution Plan in Oracle

How to read a Parallel Execution Plan in Oracle

How to Read an Execution Plan: Databases for Developers: Performance #1

How to Read an Execution Plan: Databases for Developers: Performance #1

How do I tune a SQL statement with the wrong Join Type

How do I tune a SQL statement with the wrong Join Type

Explaining Explain Plans

Explaining Explain Plans

Oracle SQL Tuning How to Read Execution Plans (Explain Plan)

Oracle SQL Tuning How to Read Execution Plans (Explain Plan)

What is an Execution Plan?

What is an Execution Plan?

Are SQL joins bad for performance?

Are SQL joins bad for performance?

Oracle Optimizer Access Methods

Oracle Optimizer Access Methods

Interpreting Oracle Explain Plan Output John Mullins

Interpreting Oracle Explain Plan Output John Mullins

Oracle SQL Plan Hash Value Flip : How to create SQL Profile identify and Fix

Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements

Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements

Understanding optimizer hints in 19c

Understanding optimizer hints in 19c

Learn To Use Explain Plans in 20 minutes and Understand Your Queries Advanced SQL

Learn To Use Explain Plans in 20 minutes and Understand Your Queries Advanced SQL

Secret To Optimizing SQL Queries Understand The SQL Execution Order

Secret To Optimizing SQL Queries Understand The SQL Execution Order

Oracle Database Performance Tuning for Admins and Architects

Oracle Database Performance Tuning for Admins and Architects

Oracle Performance Tuning EXPLAIN PLAN

Oracle Performance Tuning EXPLAIN PLAN

Recommended

Best Reason To Do A Paractute Jump Is... Proposal!

Best Reason To Do A Paractute Jump Is... Proposal!

20:44

You Are Not Alone As Long As Your Dream Is With You

You Are Not Alone As Long As Your Dream Is With You

02:22

School Battle Without Any Bulling - Is That Real?

School Battle Without Any Bulling - Is That Real?

07:20

Science Fiction Pranks Compilation

Science Fiction Pranks Compilation

07:21

Water Fails for Laughing on the Ground

Water Fails for Laughing on the Ground

10:31

Make Your Logic Say Goodbye To The Weekend Rest!

Make Your Logic Say Goodbye To The Weekend Rest!

09:54

Paul McCartney Carpool Karaoke

Paul McCartney Carpool Karaoke

23:43