Re: Detecting dying Windows-Clients w. ORA-V7.2
Date: 1996/02/16
Message-ID: <4g0sa0$sko_at_pcnet2.pcnet.net>#1/1
> Rolf Matthaei <matthaei_at_erlf80.siemens.de> writes:
> Is there anybody out there who can give me a hint how i can recognize a dying Windows Client to
> initiate a clean up in my database. we are using Oracle V7.2 in a SUN-OS-Environment with
> SQL-Net V2.
>
>>>>
The best way to do this is to create a profile at the database that checks for idle time. I usually look for about 15min idle time. This should do the trick. Now, I head that SQL*Net v2 can somehow do keep-alives and monitor itself, however, I have not been able to make this happen myself. We will be moving to Oracle 7.2 in about a month and installing SQL*Net v2.2. I will post any results I may find
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Enzo Maini
Sr. S/W Eng./Sr. Oracle DBA
Sikorsky Aircraft Corporation
6900 Maini Street
Stratford, CT 06601
Phone: (203) 386-7411
FAX: (203) 386-7457
email: enmaini_at_pcnet.com
Alt email: emaini_at_sikorsky.com
Received on Fri Feb 16 1996 - 00:00:00 CET