So over last couple of days I was modifying some code and running some exhaustive tests. I'd modify package in SQLDeveloper, run the script from sqlplus and observe progress through 'Realtime SQL monitor' window. This all works beautifully, so first kudos to the team. I also noticed the metrics window, i guess this will be enhanced in the future to incorporate more components?
However after being at this for an hour or so, I noticed progressively, the SQL editor window started getting very slow to edit code or even typing. At time it took almost a second to have the character gone after hitting backspace key. It felt as if I am typing over a 56k modem. So, I closed the RTSM window, hoping that would speed things up, but no it did not. Only way I got rid of that slowness, was to save all the code to a file, exit out of SQLDev and then restart/reconnect.
I repeated this test again and it behaved the same, so I'd like to know if there is a way to identify if RTSM leaves a thread hanging in the background after window exits? how can one find out? Wen it happens again, is there anything specific you'd want me to do to capture info? My desktop is sufficiently powerful, 4 cores, 16GB mem, 64bit Win7 pro.
Thanks
Raj