| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hanging processes on NT
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:paled_at_home.com] Sent: Wednesday, September 12, 2001 12:15 PM To: Multiple recipients of list ORACLE-LSubject: 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).Received on Wed Sep 12 2001 - 14:48:23 CDT
 |
 |