Viewing DBMS_XPLAN output

[SJM]

Can we get an option to have the Explain Plan feature return output from DBMS_XPLAN.DISPLAY rather than the current grid? To me the output is more readable in this format, and any enhancements in newer versions of Oracle would automatically be supported.

 

[Marco van der Linden]

This should be an option then, as in Oracle 8i dbms_xplan is non-existent. (Hey, I told them to upgrade to at least 9i several times )

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[SJM]

I agree, it should be an option, specifically for that reason. I'd like to see DBMS_XPLAN be the default, though