Message-Id: <22541.293528@fatcity.com> From: =?iso-8859-1?q?Connor=20McDonald?= Date: Wed, 11 Sep 2002 13:30:46 +0100 (BST) Subject: Re: Detect long running jobs where user shuts down their workstation. SQL Net has a dead connection detection (dcd) mechanism where it will poll the client occasionally to make sure they are still alive. If not, the session is killed. In my experience though this has generally been the equivalent of a ping - so a user that bounces their pc or kills a task, but their pc remains accessible on the network does not qualify for the dcd. hth connor --- Rick_Cale@teamhealth.com wrote: > Hi All, > > We have users who sql access who will issue long > running queries(you know > the type) and just shuts down their computer while > running. > > I assume once sent to the server that server is > still executing it or will > it die once connection is broken. Can someone > explain what actually > happens in this scenario. > > Is there anyway to detect/kill process. > > Thanks > Rick > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: Rick_Cale@teamhealth.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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts