HomeНаука и техникаRelated VideosMore From: Maria Colgan

Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

166 ratings | 7517 views
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.
Html code for embedding videos on your blog
Text Comments (18)
Savita Raj (5 days ago)
Great Insights!!!! Thanks for sharing it
Hashir Riaz (19 days ago)
Very Informative Session. Could you please create a video on how to use PARALLLEL, USE_NL, ORDERED_PARALLEL etc
parthiban kumar (23 days ago)
I was stunned by the way you have explained the flow. Great work keep it up,subscribing your channel now :)
Johannesburg0507 (1 month ago)
Thank alots, this was really very useful and this is how online lectures videos should be made.
ONKAR TIWARI (3 months ago)
Simply superb
Nirupan Raju (6 months ago)
Many thanks for the information really usual.
Thabo Mahlaba (7 months ago)
Best explanation I have found on Youtube so far. Thanks for this.
ASHISH SHARMA (7 months ago)
Thanks for sharing your knowledge in this video. I really find it very useful.
ken Han (10 months ago)
Great video, thanks
seshu babu (11 months ago)
Great one.thanks!!!
Najeeb Khan (1 year ago)
Excellent presentation and the way u explain directly goes in head
Mohammad Mannan (1 year ago)
good explainnation .....
Mohanraj Rudra (1 year ago)
awesome.. explanation.. thanks :)
mayank s (1 year ago)
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
Alan O'Brien (1 year ago)
Hey Maria, your really good at this... ever think of doing it more ..... cheers!
Marcel Ginga (1 year ago)
very clear explanation! thank you!
Zikri Askin zach Ince (1 year ago)
perfect presentation. thanks a million for sharing.
Chris Stephens (1 year ago)
great content. please keep it up!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.