Feature Request: Disconnect Inactive Sessions

[Miles]

The DBA's recently implemented a session limit on our databases (maximum of 10 sessions). Every window in PL/SQL Developer keeps an open session (once the session for that window has been established). This means that I can only have 10 functional windows open in PL/SQL Developer, even if 9 of them are inactive.

Could you implement a feature (preferably triggered as a menu item with a shortcut key) to disconnect/close all sessions that are inactive? Or a feature allow the user to choose and close individual sessions (e.g. from the Window List)?

-Miles

 

[patch]

Wouldn't using the 'single session' option be the solution to this?

regards,
Patrick

 

[Miles]

I tried that. In "single session" or "dual session" I can only execute one query at a time. I usually have about 15 windows open with 1 to 3 queries active at a time (usually at least one query takes several minutes).

As a work around the "single session" limitation, I could open multiple instances of PL/SQL Developer (which I currently do to connect to multiple databases simultaneously). However, mulitple instances require much more (local) system resources and there are still issues sharing configuration and history across instances.