Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

preview_player
Показать описание
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.
  1. Maria Colgan (SQLMaria)
  2. DBMS_XPLAN.DISPLAY_CURSOR
  3. Oracle Database
  4. Execution Plans
  5. Query Tuning
  6. Query Plans
Рекомендации по теме
Using DBMS_XPLAN.DISPLAY_CURSOR to 0:12:33

Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

Review Actual Plan 0:20:04

Review Actual Plan using DBMS_XPLAN.DISPLAY_CURSOR PART -1

Adaptive Cursor Sharing 0:05:42

Adaptive Cursor Sharing

Review Actual Plan 0:23:41

Review Actual Plan with DBMS_XPLAN.DISPLAY_CURSOR PART-2

Oracle SQL Performance 0:00:45

Oracle SQL Performance Tuning Day 20 - Execution Plan - Summary

How to Read 0:09:34

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

Read Oracle SQL 0:24:53

Read Oracle SQL Execution Plan | DBMS XPLAN

DBMS_XPLAN : Compare 0:04:08

DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c

Oracle Performance Tuning 0:17:43

Oracle Performance Tuning - Read and interpret Explain Plan

Peeking on steroids: 0:06:23

Peeking on steroids: Adaptive Cursor Sharing

Learn To Use 0:20:23

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

Oracle SQL Tuning 0:08:20

Oracle SQL Tuning - Explain Plan Lies?

Oracle SQL Tutorial 0:12:54

Oracle SQL Tutorial : Using execution plan to optimize query in oracle

XPLAN_ASH Active Session 0:18:15

XPLAN_ASH Active Session History - Introduction

How to Generate 0:04:46

How to Generate an Execution Plan in Oracle

AskTOM TV - 0:06:15

AskTOM TV - SQL Plan Directives from DBMS_XPLAN

Explain the Explain 1:26:51

Explain the Explain by Maria Colgan

How To Generate 0:06:30

How To Generate Explain Plan For SQL Queries In Oracle Database ? #oracle

Parallel Execution Skew 0:03:37

Parallel Execution Skew in less than four minutes

Slow SQL Query? 0:15:38

Slow SQL Query? Get the Plan in Oracle SQL Developer!

Oracle Advanced SQL 0:25:40

Oracle Advanced SQL Optimization Techniques

SQL Gone Wild! 0:46:00

SQL Gone Wild! – Taming and Tuning the Oracle Optimizer by Gavin Soorma

Calculate query performance 0:09:14

Calculate query performance with Explain Plan in Oracle PLSQL.

Oracle Performance tuning 0:13:36

Oracle Performance tuning | Oracle hard parse vs soft parse

Комментарии
Автор

very clear, rich and competent teaching. The speed and the pronunciation of your talk is perfect.

othmarlippuner
Автор

Best explanation I have found on Youtube so far. Thanks for this.

thabomahlaba
Автор

I was stunned by the way you have explained the flow. Great work keep it up, subscribing your channel now :)

parthibankumar
Автор

I have just went through further all your explain plan videos! Great learning channel!

humayunhimu
Автор

Great Video, Maria. Really helpful. You have explained "DBMS.EXPLAN.DISPLAY_CURSOR" package perfectly.
I appreciated your efforts.

samirmomin
Автор

Really this is useful and same Oracle has been automated by using SQLT. Thanks a lot to explain it in easy method.

rakesh-wm
Автор

perfect presentation. thanks a million for sharing.

zikriaskinince
Автор

Thanks a lot video madam.... Great respect for you..please Keep posting more video

rakeshranjankumar
Автор

Thank alots, this was really very useful and this is how online lectures videos should be made.

shekhar
Автор

Excellent presentation and the way u explain directly goes in head

najjuizzhere
Автор

Good work... thanks. please do share on how to use sql monitoring from oem and how to tell which operation step of plan currently being executed by query...

bilkishg
Автор

basic steps clearly explained for beginners

madhavjpn
Автор

I dono why less number of subscribers for this channel.. good channel for better learning..

googdriveforme
Автор

Outstanding clarity and value of the content. Thanks!

alex
Автор

Really awesome!!, Please explain about gathering stats for tables and indexes.

ramchinthakayala
Автор

Very Informative Session. Could you please create a video on how to use PARALLLEL, USE_NL, ORDERED_PARALLEL etc

hashirriaz
Автор

Thanks for sharing your knowledge in this video. I really find it very useful.

ASHISHSHARMA-yxdr
Автор

Great explanation, can you please make video which clearly explain best Join method in case of big query having more than 5 table joined, like which table should come first and so on, and to modify joining order using Hints

mayanks
Автор

Great Insights!!!! Thanks for sharing it

savitaraj
Автор

Many thanks for the information really usual.

NirupanRaju