PL/SQL developer make my server slow

yansun

Member
First of all, PL/SQL developer is a wonderful tool for PL/SQL programer. Now I cannot work without it. But I have a serious problem with it and don't know why.
My computer is connected to a remote database server through VPN. Whenever I login on the database server though PL/SQL developer, after some operations, the server will become very slow. The DBA told me that the PLSQLDev.exe is checking table sys.all_queue in an infinit loop.
Once the DBA kills the PLSQLDev.exe session, the server becomes normal.
The other problem is that when I login off server through pl/sql developer, the session will keep running on the server until DBA kill it.
 
Strange. Can you let me know the exact SQL text that runs an "infinite loop"? As far as I know PL/SQL Developer does not execute server side loops at all.
 
Macro:
Thank you for your reply.
I don't know the exact SQL text right now. The loop doesn't happen right after I login on the server. It starts after some operations. And I'm not sure what trigers the problem. Next time, when it happens, I will write down the SQL text and let you know.

Thanks
 
Back
Top