When an MS-Windows client crashes or the PC is turned off without
properly ending the application, the session on the Oracle server
remains forever open. This is a waste of ressources, apart from DBMS
locks that may also be held forever and block other users.
It seems that the underlying TCP/IP is used by SQL*Net without the
KEEPALIVE option, which could help in detecting dead clients. Is there
any way to turn on this option ?
I do not want a DBA to regularly check on the server side and manually
kill dead sessions. I want an application that can turn 24 hours a day
without administration.
I'm using Oracle 7.1.16 on RS/6000 and SQL*Net 2.0 with Pro*Cobol and
ODBC on MS-Windows.
Please let me know how you solved this problem.
Guenter Brors - Consultant Client/Server Solutions
Internet: brorsg_at_ibm.net
CompuServe: 100137,2305