expertise on save / recover current PL/SQL setup

[kujoku]

Hi,

Often times I have atleast 4 PL/SQL developer programs connected to different databases at the same time (dev, test, prod databases). Each of those have atleast 8 to 10 PL/SQL windows, for eg: Edit window for a package, SQL window for some queries, Program window, etc.

Given this scenario, each of those 4 programs tend to grow in virtual memory size and reach around 100 MB within a week or so!!

Now the problems I want expert advise on are these:
1. Is there anyway for the virtual memory (of PLSQL developer) to be reduced by doing say "garbage collection" or some other memory optimization? Ofcourse removing any "memory
leaks" within the program would help too...

2. More importantly, how can I shutdown my machine, reboot and go back to the same setup without losing/wasting much time in trying to save all of my open & unsaved windows?

I do have a trick that I accidently discovered: Simply close the PLSQL developer using the "End program" when you press "Ctrl-Alt-Del". When the machine is rebooted, restart PLSQL developer and it will ask you to choose one of the previous (recovered) sessions. However, this is a very unreliable way to achieve what I want. Any thoughts?

Thanks.

 

[Marco Kalter]

The memory usage growth indicates a memory leak in PL/SQL Developer. Can you let me know your PL/SQL Developer version?

To save all work in a PL/SQL Developer instance, go to File > Save All. There is no preference that will automatically save all your work on exit.

 

[Bo Pedersen]

The autosave desktop option saves the window layout on the exit of the last PL/SQL Developer, so the same windows are opened on the next start. To achieve your desired goal when working with multiple sets of window layouts, the autosave desktop feature shall be enhanced to save multiple desktops and selecting which one to use on restart.

It could be a nice feature. Currently I'm very careful with which PL/SQL Developer session I terminate last in order to restart with this one setup.

 

[William Robertson]

"File > Save All" prompts for names and locations. What would be really handy would be a fast way to exit without prompts that used the existing crash recovery system cleanly.

Often I have quite a few windows open, in various states, some not yet named. When I log off I then have to go through deciding what to do with each one, whether I want to save it, if so where and what to call the file. Good practice of course, but wouldn't it be handy sometimes just to "fast exit" and know that everything will be restored next time I start up PL/SQL Developer?

This shouldn't be hard to implement since it can already do this for crash recovery, and people are clearly force-quitting from Task Manager just to achieve this useful behaviour.

 

[gad]

Hello,
I asked for the same thing some(long) time ago.
What's the word on that this days?

gad

 

[Marco Kalter]

It's still on the to-do list with some priority (we have had quite a few requests for this).

 

[matjazc]

You have one more

Regards,Matjaz

 

[Marco Kalter]

The current 7.0.3 version has a desktop= command-line parameter. This will save/restore the desktop in the same way as the crash recovery feature.