From daemon Tue Jan 9 16:51:01 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA15141; Tue, 9 Jan 1996 16:50:58 -0500 Message-Id: <9601092150.AA15141@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 3162; Tue, 09 Jan 96 16:24:43 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 8299; Tue, 9 Jan 1996 16:24:41 -0500 Date: Wed, 10 Jan 1996 07:21:00 +1000 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Tony Jambu 041 985 2628 Subject: Re: SQLNET V2 question X-To: Bill Cole - 919-248-6118 X-Cc: ORACLE-L@CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L In-Reply-To: <9601091855.AA05668@escssv1> from "Bill Cole - 919-248-6118" at Jan 9, 96 01:55:03 pm Bill > > > We're still on V1 sqlnet and have an ongoing problem with our PC > > connections. When a PC based client re-boots their PC during an active > > connection to the database, that session's daemon usually does not go away > > on the UNIX side and often seems to run away eating up CPU as fast as > > possible. > > Question: Does anyone out there know how V2 sqlnet handles this type of > > lost connection? > > Not very well. I just tried it on a test database. I established a > connection from the PC then recycled the instance on the server. When I > tried a query after recycling, I got "end of file on a communications > channel". > Bill, I think you may have misread the original email. The question is what happens to the server connection from the client if the client is rebooted. Not what happens to the client if the server is rebooted. To answer to original question. SQL*Net V2 handles this well. There is a keepalive parameter that is set on the server end that probes the client to see if it is still there. It works and we are using it. You need to have the following in your sqlnet.ora file sqlnet.expire_time = 1 (units in minutes) For Oracle 7.1.3 on Solaris, there is a patch that Oracle fix a problem where idle connections were being killed. ta tony -- ______________________________________________________________________________ _____ ________ / ___|Tony Jambu, Database Consultant /_ _ /_ __ / |Wizard Consulting,Aust (ACN 065934778) /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003@compuserve.com FAX: +61-3-4163559 \_______/ |EMAIL:TJambu@wizard.com.au PHONE: +61-3-4122905