Re: Hanging processes on NT

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_at_kmg.com
> --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_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_at_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).