I downloaded SQL Developer 18.2 after watch this video. Thanks for introduce.
@JeffSmiththat
6 жыл бұрын
jeong hun Choi you're very welcome! Let me know if you have any questions.
@dejankovacevic153
4 жыл бұрын
Proposal for a new version. Mark explain plan with numbers so we can easily see execution order. Thank you
@JeffSmiththat
4 жыл бұрын
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
4 жыл бұрын
@@JeffSmiththat That would be a big deal for users.
@antoanetavatova2120
2 жыл бұрын
Thank you. What is the tool, that you use to zoom and write over with a red pen?
@JeffSmiththat
2 жыл бұрын
for Windows, ZoomIt
@lakshmim8433
2 жыл бұрын
How did you open real time SQL monitor page?
@JeffSmiththat
2 жыл бұрын
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'
@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.
@rakeshpanigrahi577
5 жыл бұрын
Thanks a lot, could you please recommend any good books to tune queries
@JeffSmiththat
5 жыл бұрын
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
@kevinzhang8974
4 жыл бұрын
@ 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
4 жыл бұрын
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
4 жыл бұрын
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.
Пікірлер: 22