Disconnected session from ODT leaves inactive session in database
I am using ODT 11g beta accessing a remote Oracle XE through wireless connection. every time wireless connection dropped. I have to close connection and refresh it to regain access to oracle server. This is fine until today I got "ORA-12516: TNS:listener could not find available handler with matching protocol stack". When I checked database session using XE's APEX there are about 20 inactive sessions for devenv.exe eventhough VS IDE already closed.
Any idea?
Thanks,
NH