ThatJeffSmith

Tag: autotrace

SQL Developer 4.2 Oracle Execution Plans – More Columns Available

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… […]

Similar Posts by Subject Areas: , , ,

Demo: AutoTrace – Generate Hints and Compare Different Execution Plans & Stats

For some reason I procrastinated setting up my video software on my new work machine. Big mistake. I put together this animated GIF to show some new things in version 4.2: Updated formatter – better support for ANSI joins Opening objects referenced in your execution plans Inserting Hints Not new but underutilized: how to compare […]

Similar Posts by Subject Areas: , , , , ,

Why Is My SQL Slow & Go Faster Features

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 […]

Similar Posts by Subject Areas: , , , , ,

Explain Plan ‘Notes’ in Oracle SQL Developer

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 […]

Similar Posts by Subject Areas: , ,

30 SQL Developer Tips in 30 Days, Day 10: Compare Stuff Side By Side

We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B. So let’s look at a few scenarios. Execution Plans or Autotrace Runs Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila. Looking at […]

Similar Posts by Subject Areas: , , , , , ,

Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4

“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 […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,