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

[@jeonghunchoi658]

I downloaded SQL Developer 18.2 after watch this video. Thanks for introduce.

[@JeffSmiththat]

jeong hun Choi you're very welcome! Let me know if you have any questions.

[@danayoung4460]

Good to know, thank you so much! I am wondering if there are any tips to deal with slowness when export big query result from Oracle SQL, I used export to text file to clipboard, it is better than excel or csv, but it's still unbearably slow.

[@JeffSmiththat]

When you do an export, we re-run the query. You can avoid this, see www.thatjeffsmith.com/archive/2012/03/how-to-export-sql-developer-query-results-without-re-running-the-query/

[@danayoung4460]

@@JeffSmiththat good to know! thank you so much.

[@dejankovacevic153]

Proposal for a new version. Mark explain plan with numbers so we can easily see execution order. Thank you

[@JeffSmiththat]

i like the idea, and the plan table even has a column that shows execution order, but it's not reliably populated by the optimizer, so this isn't as easy as it sounds

[@dejankovacevic153]

@@JeffSmiththat That would be a big deal for users.

[@antoanetavatova2120]

Thank you. What is the tool, that you use to zoom and write over with a red pen?

[@JeffSmiththat]

for Windows, ZoomIt

[@rakeshpanigrahi577]

Thanks a lot, could you please recommend any good books to tune queries

[@JeffSmiththat]

Old, but still great Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) www.amazon.com/dp/1590596366/ref=cm_sw_r_other_apa_i_m8jKDbH503YS2

[@lakshmim8433]

How did you open real time SQL monitor page?

[@JeffSmiththat]

Two ways, you can go to Tools menu and select 'Real Time SQL Monitor' or on DBA panel, for your connection, scroll down to Tuning part of tree and see item for 'Real Time SQL Monitor'

[@kevinzhang8974]

@ 1min47second, you click something to show the actual SQL "explain plan set ....". Can you tell me what you have clicked? I can't seem find that magic click. Thanks!

[@JeffSmiththat]

Go to the View menu, click on 'Log' - on the bottom of your desktop, you'll see the Log panel, and on that, you'll see a tab called "Statements." That's what you're looking for.

[@kevinzhang8974]

figure it out after some research. That is the "Statement Log". To enable it by clicking View (menu) ==> Log (or Ctl + Shift + L). Very cool feature. Learned something very useful today.

[@MrBHASKARSOMASANI]

thanks.

[@cut-no-one4082]

Keep up the good help ! @-,-'--

[@JeffSmiththat]

Thanks I C!