ThatJeffSmith

SQL Developer 4.2 Oracle Execution Plans – More Columns Available

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.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Similar Posts by Content Area: , , ,