Hi Guru's
Please help, I am running Oracle 8.1.7 on Windows 2000.
The problem is a third party product runs a jdbclient connection to the database, but it does not seem to disconnect.
So over time we have a build up of connected sessions using jdbcuser (Osuser). I have tried killing the sessions with TOAD, but the remain connected with a status of KILLED. They never drop - until the database is shutdown and restarted.
As you can imagine the database quickly reaches MAX NUMMBER OF SESSIONS EXCEEDED and I really cann't keep stopping starting the db.
I am managing to hold out by killing the idle users.
Please has anyone else experienced this and is there some solution?
TIA
Denham
This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
