SQL Developer 4.2 Oracle Execution Plans – More Columns Available

thatjeffsmith SQL Developer 9 Comments

Tell Others About This Story:

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…

Partition Columns is kinda new - it will just grab all 3 partition themed bits.

Partition Columns is kinda new – it will just grab all 3 partition themed bits.

So let’s look at a plan from V$SQL_PLAN…a la hitting this button –

Click the drop-down, then select the entry you want to see. If you don't see anything available, run  your query again.

Click the drop-down, then select the entry you want to see. If you don’t see anything available, run your query again.

42_plans2

For AutoTraces you can also ask to hide a column if all its values are NULL.

Tell Others About This Story:

Comments 9

  1. I see entries on the list, but I really need to click on it to know what I’m looking at. See my off-thread comment where dba is helping me.
    Thank you,
    john3

  2. DBA ran sql developer as me, on his pc… and it works. We think it may relate to my network work-group rights. My boss sees hers as grayed out also. Thanks for the help. I’ll try to come back and verify when I have it running.
    john3

  3. I use SQL Developer, only.

    I just had a dba run one as me, and the drop-down is not grayed out. This is looking like a permissions issue.

  4. I only see 3 grayed-out entries on the drop-down.

    How can I actually see an explain plan in SQL Developer?

    Sorry for posting here, but I found previous post asking the same question a few years back. At that time I think you said it was a bug? …and had been reported for fixing?

    Help?
    john3

      1. thatjeffsmith Post
        Author
        1. I do see the public synonym (v$sql_plan), but cannot see the table (V$_SQL_PLAN) under schema: sys. My SQL Developer drop-down looks very much like the demo, just grayed out. I feel like maybe I should just start a support ticket.

          1. thatjeffsmith Post
            Author

Leave a Reply

Your email address will not be published. Required fields are marked *