Re[2]: Detect long running jobs where user shuts down their

From: <dgoulet_at_vicr.com>
Date: Wed, 11 Sep 2002 09:42:48 -0400
Message-Id: <22541.293539@fatcity.com>

Connor,

    I tried DCD several times over the years. It worked sporadically at best and caused many other connection/remaining connected problems that OTS recommended we discontinue using it. Also in my experience it did nothing while a long running query was running, only worked if the client was in an idle state.

Dick Goulet

____________________Reply Separator____________________

Subject: Re: Detect long running jobs where user shuts down their wor Author: =?iso-8859-1?q?Connor=20McDonald?= <hamcdc_at_yahoo.co.uk> Date: 9/11/2002 5:33 AM

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_at_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_at_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_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).
  

  ---

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 http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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

Received on Wed Sep 11 2002 - 08:42:48 CDT