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.

[@othmarlippuner3197]

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

[@thabomahlaba5193]

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

[@samirmomin203]

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

[@humayunhimu6045]

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

[@parthibankumar1962]

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

[@rakesh-w7m]

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

[@zikriaskinince9708]

perfect presentation. thanks a million for sharing.

[@todorowael]

Thank you for the great explanation!

[@humayunhimu6045]

Mind blowing Maria! You are superb!

[@rakeshranjankumar7094]

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

[@shekhar0507]

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

[@yulianloaiza]

You an MVP!! Love your site

[@madhavjpn567]

basic steps clearly explained for beginners

[@learner5358]

Thank you for this content !!

[@najjuizzhere]

Excellent presentation and the way u explain directly goes in head

[@peterlisp3399]

Great, thanks!

[@alex444000]

Outstanding clarity and value of the content. Thanks!

[@gopikanagal2141]

Great understanding & explanation

[@AparnaBL]

Thanks Maria. you are a life saver.

[@bilkishg5824]

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...

[@googdriveforme4115]

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

[@ASHISHSHARMA-yx8dr]

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

[@ziadfawzi]

Very useful session. Thanks a lot.

[@babakvahidnia206]

You are my hero

[@cstephens16]

great content. please keep it up!

[@humayunhimu6045]

I learned a lot.

[@karthikeyand386]

Very good Explanation Thanks Lot :)

[@AmitKumar-pl4qm]

Nice one

[@savitaraj1442]

Great Insights!!!! Thanks for sharing it

[@ramchinthakayala2092]

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

[@onkartiwari5742]

Simply superb

[@NirupanRaju]

Many thanks for the information really usual.

[@chupycapry]

very clear explanation! thank you!

[@hashirriaz3147]

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

[@ramramaraju2221]

Great video:)

[@SQLMaria]

Glad you enjoyed it

[@massefromla2554]

Thank you Maria , awesome

[@varunchinnasamy5420]

Thanks.

[@anandmohite]

thanks a ton

[@juno7893]

👏🏻👏🏻👏🏻

[@mayanks6728]

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

[@mohanvilla0789]

awesome.. explanation.. thanks :)

[@kevin0318-g3p]

Great video, thanks

[@seshub7555]

Great one.thanks!!!

[@quannguyen185]

thanks for your share

[@madhusudanaraonallamothu2792]

Thank you

[@gopikanagal2141]

Can you please create understanding advance AWR in 19c step by step. It really helps the DBA

[@ravinbharathmaharaj9269]

Can you share in a percentage format the execution for each line

[@ztech4634]

Do you offer a course on performance tuning?

[@budmonk2819]

Are you the Maria behind MariaDB???

[@SQLMaria]

I'm afraid not Bud. MariaDB is named after the founder's daughter and not me. 🙂

[@conorcasey3466]

is there a hint of an Irish accent there ?

[@SQLMaria]

Indeed there is! I'm originally from Dublin.

[@conorcasey3466]

@@SQLMaria , can always detect one of our own 😁 Great content BTW!