From paled@home.com Wed, 12 Sep 2001 09:10:41 -0700 From: Paul Drake Date: Wed, 12 Sep 2001 09:10:41 -0700 Subject: Re: Hanging processes on NT Message-ID: MIME-Version: 1.0 Content-Type: text/plain Ron, If they are connecting through sql*net (as opposed to bequeath) the parameter in the sqlnet.ora file on the server SQLNET.EXPIRE_TIME = 10 should poll for dead connections. Not sure of this implementation on 7.3. Is the client 7.3 and server 8.x? Paul "Smith, Ron L." wrote: > > I have a problem with processes not ending on NT. I don't know if they are > my scheduled batch jobs that call SQLPLUS or if someone is logging on to > SQLPLUS and then not logging off. When I look at the Task List I have > several copies of SQLPLUS.EXE and PLUS33.EXE running but noone is logged on > to the database. The batch jobs are run through the AT command as CMD-EXE > /c (batchfile). All the SQL code contains an exit at the end. > > Is there any way to make these go away automatically? > > Thanks! > Ron Smith > Database Administrator > rlsmith@kmg.com > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: paled@home.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).