Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Feature Request: Explain Plan

Ray007Apr 13 2021

It would be nice if I could put a query in and explain the plan for it.
My current work-around is to run this:

explain plan for

select something super special

from lots_of_tables

where something is awesome;

select * from table(dbms_xplan.display);

The problem is that the display is hard to read. Is there a way to set this to used a fixed width font in the results?

Comments

Hi Ray,
Sorry that the explain plan looks so bad in the output.
When the select output doesn't look good with our extension, the workaround I have been using is the SPOOL command. I find that the file output tends to be easier to read in some cases.
Can you please try adding:
spool c:\myfolder\myspoolfile.txt

1 - 1

Post Details

Added on Apr 13 2021
1 comment
62 views