I downloaded SQL Developer 18.2 after watch this video. Thanks for introduce.
@JeffSmiththat6 жыл бұрын
jeong hun Choi you're very welcome! Let me know if you have any questions.
@dejankovacevic1534 жыл бұрын
Proposal for a new version. Mark explain plan with numbers so we can easily see execution order. Thank you
@JeffSmiththat4 жыл бұрын
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
@dejankovacevic1534 жыл бұрын
@@JeffSmiththat That would be a big deal for users.
@MrBHASKARSOMASANI3 жыл бұрын
thanks.
@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.
@antoanetavatova21202 жыл бұрын
Thank you. What is the tool, that you use to zoom and write over with a red pen?
@JeffSmiththat2 жыл бұрын
for Windows, ZoomIt
@cut-no-one40825 жыл бұрын
Keep up the good help ! @-,-'--
@JeffSmiththat5 жыл бұрын
Thanks I C!
@lakshmim84332 жыл бұрын
How did you open real time SQL monitor page?
@JeffSmiththat2 жыл бұрын
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'
@rakeshpanigrahi5775 жыл бұрын
Thanks a lot, could you please recommend any good books to tune queries
@JeffSmiththat5 жыл бұрын
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
@kevinzhang89744 жыл бұрын
@ 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!
@JeffSmiththat4 жыл бұрын
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.
@kevinzhang89744 жыл бұрын
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.