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…

So how do you see the Explain Plan notes in SQL Developer?

The database writes that plan meta data to the plan table and its OTHER_XML column.

So in the preferences, if you turn that on…

Explain Plan Preferences, toggle on OTHER_XML
Explain Plan Preferences, toggle on OTHER_XML

Then you’ll see stuff like this when you use the Explain/Autotrace GUI tools in SQL Developer (vs running Explains manually in the worksheet a la SQL*Plus) :

All kinds of goodie info in here - in fact, I'm guessing a little more than Stewart is looking for...
All kinds of goodie info in here – in fact, I’m guessing a little more than Stewart is looking for…

Hard to see that?

Some cool notes...
Some cool notes…

I would say that I’m glad to make Stewart happy, but I’m guessing he’ll have some ideas on how to make this even better 🙂

P.S. I wrote this post on my Mac…

…and I just about got screen zooming and screenshots down using the native bits. But I must say, I really do miss having SnagIt on the Mac. So much nicer to do post-capture effects on my Windows setup.

thatjeffsmith
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

4 Comments

  1. Matthew Sultana Reply

    Is there a quick way of seeing the order in which the EP branches are accessed ?

  2. I just gave this a proper run through. Very, very nice Jeff… tons of great information in there… things that I actually DON’T get in the Notes in SQL Plus.

Write A Comment