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____________________
Author: =?iso-8859-1?q?Connor=20McDonald?= <[EMAIL PROTECTED]>
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
--- [EMAIL PROTECTED] 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: [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).
=====
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
