Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!src.honeywell.com!cim-vax.honeywell.com!tdoyle
From: tdoyle@cim-vax.honeywell.com
Newsgroups: comp.databases
Subject: Re: Cancelling a query in Oracle on Unix
Message-ID: <1991Mar22.173356.53@cim-vax.honeywell.com>
Date: 22 Mar 91 23:33:56 GMT
References: <49507@seismo.CSS.GOV>
Organization: Honeywell CIS
Lines: 17

In article <49507@seismo.CSS.GOV>, bonnett@seismo.CSS.GOV (H. David Bonnett) writes:
> 
> We are looking for a way to cancel a query that is in
> progress from within a Pro*C application. It is quite 
> possible for our users to cobble up a query that will
> not finish for many moons and we want to be able
> to kill these off.  We are using the two-task driver
> on TCP-IP on Sun 4's with Oracle v6.0.27.8.1.
> 

How about simply sending a terminate signal to the process. On Systen V
Unix it would be:
      kill -15 <pid>
    or a more rude
      kill -9  <pid>

Bipin Prasad   bprasad@honcim1.honeywell.com