Video: Explain Plan, Execution Plan, AutoTrace, and Real Time SQL Monitoring

thatjeffsmith SQL Developer 0 Comments

15 minutes overview of how to use these features in Oracle SQL Developer: Get an Explain Plan Customize the display of the plan Get a cached plan Use DBMS_XPLAN Compare Plans Use Real Time SQL Monitoring Use AutoTrace. And if you want an awesome video, MUCH more in depth about how to read a plan, then I suggest this from …

SQL Developer 4.2 Oracle Execution Plans – More Columns Available

thatjeffsmith SQL Developer 19 Comments

Someone on the Forums (yes, we read and respond!) noticed they couldn’t add Bytes or Time to their plan displays in Oracle SQL Developer. So we just made all of the columns available now, even if a few them might not make sense, i.e. TEMP_SPACE, OTHER. Preferences – Database – Autotrace/Explain Plan New things highlighted/boxed… So let’s look at a …

Why Is My SQL Slow & Go Faster Features

thatjeffsmith SQL Developer 19 Comments

Yesterday I made my first presentation ever at the annual Hotsos conference. The topic: “All of the Performance Tuning Features in SQL Developer.” It went pretty well, and I’d like to share those slides now with y’all: Tuning & Diagnostics Features in Oracle SQL Developer from Jeff Smith Easier to Read Autotrace Execution Plans Apparently I said ‘explain plan’ too …

Explain Plan ‘Notes’ in Oracle SQL Developer

thatjeffsmith SQL Developer 4 Comments

Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus… @thatjeffsmith See… no execution… and the notes. With one little statement. pic.twitter.com/w3GYkIPaDY — Stewart Bryson (@stewartbryson) November 4, 2014 So how do …

Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4

thatjeffsmith SQL Developer 41 Comments

“Explain Plans are useless.” Yikes. Really? Don’t we spend all day looking at execution plans? To clarify, I would say that explain plans could be useless. If you do an Explain, you’re actually looking at a theoretical plan, not the ‘actual’ plan. From the docs: With the query optimizer, execution plans can and do change as the underlying optimizer inputs …