Oracle "sniped" Connections

[danieljgates]

Has anyone heard that PL/SQL Developer can leave "sniped" connections within Oracle that do not get cleaned up?

I have been working with PL/SQL Developer for about 2 years and have never had an issue. I recently switched jobs and would like to convince our DBA Team Lead that it is ok, but he refuses to believe me. I cannot find any documentation on this and since I currently do not have DBA privs, I cannot prove/disprove this.

Thanks.

Daniel

 

[Stew Stryker]

Is this DBA suggesting that PSD somehow leaves the connection to Oracle open after you close the program? Or that someone can watch your network connection for transaction data?

Sounds like paranoia to me! But what do I know???

Out of curiosity, does anyone know if our login info is somehow encrypted when we connect to Oracle? That's the only way I could see them getting captured/stolen.

 

[danieljgates]

The DBA is stating that the "sniped" connections are being left behind in the database after you close PL/SQL Developer and will continually grow until they are manually cleaned up or the database bounced. I do not think they are concerned with respect to transaction data.

 

[mike]

That's unfortunate for you. I haven't heard of this before. I've been using it for about 5 years and our DBA's haven't complained and the sessions window doesn't ever show prior sessions running from PL/SQL Developer that I've noticed.

I don't recall there being a topic of this in the forums either. I'm curious where the DBA got this information. It might help to ask him.

I wonder if they would be willing to let you try it for a little while they keep an eye out for this to prove their point. I would think a couple runaway sessions wouldn't be that hard to clean up, right?

Good Luck,

Mike

 

[danieljgates]

Yes, I believe they are simple to clean up, as I have found a few solutions out there on the web. I will see if I can prove this on my own.

 

[Stew Stryker]

Daniel,

I've been using PSD for a couple years now and, like Mike, have never seen or heard of PSD leaving your Oracle connections open.

FWIW, I just had 3 Oracle connections open via PSD and after I closed PSD they were all gone.

Hey maybe the DBA is pulling your leg, sending the new guy on a "snipe" hunt???

If not, then s/he's working from bad data.

Good luck!

 

[danieljgates]

I decided to move forward and get the 30 day trial and will check the db for processes in a couple of days. If there are none, I can go back to the DBA and prove my point. Thanks for the responses.

Daniel

 

[johnsok]

Has anyone heard that PL/SQL Developer can leave "sniped" connections within Oracle that do not get cleaned up?

Never have seen this behavior, and I have been using PLSD since version 3.something.

 

[Marco van der Linden]

I _do_ have this sometimes, but only in one case...When debugging and my VPN connection dies on me I have to logoff/logon again to re-establish my db connection. Looking in the sessions window, will show that the debug session is still there. But hey, there's a 'kill' button.........