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
Received on Wed Sep 11 2002 - 07:30:46 CDT