| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Hanging processes on NT
Hi Ron,
You should look if the jobs really work. I know that there are some problems with AT scheduled jobs on NT. I think your jobs don't come to end, so the processes are still open.
regards
Volker Schoen
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
-----Ursprüngliche Nachricht-----
Von: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
Gesendet: Mittwoch, 12. September 2001 17:00
An: Multiple recipients of list ORACLE-L
Betreff: Hanging processes on NT
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: Smith, Ron L.
INET: rlsmith_at_kmg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 12:37:20 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |