Requests

[-IceTea-]

Hi,
The following things would really help me when
using pl/sql developer:

1) The ability to choose the columns shown in the sessions window.

2) The ability to compare between two execution plans. This can be done by simply giving an option to use an external tool like windif and exporting the two execution plans to text without the cost and other columns that interfere.

3) The ability to show the _current_ execution plan of an SQL by its SQL_ID or HASH. What I mean by this is not issuing a 'explain plan for' for a query, but showing the output of DBMS_XPLAN.DISPLAY_CURSOR (in versions where this is available). Preferably this should also be present in the session window for quick access so one could use it for a query that is currently running.

Thank you,
Jonathan.

 

[Marco Kalter]

1) The ability to choose the columns shown in the sessions window.

This is already possible. You can define the query for both the sessions (upper half) and session details (lower half). These queries determine the columns, and the order of the columns.

I have added your other 2 suggestions to the list of enhancement requests.