That's the problem. Should... It never worked for me (8.1.5, 8.1.6) and I had to write a script to take care of these types of connections.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-----Original Message-----
From: Paul Drake [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L
Subject: 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
> [EMAIL PROTECTED]
> --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
