Re: long query

From: <nightwalker_ru_at_my-deja.com>
Date: Wed, 01 Sep 1999 06:16:30 GMT
Message-ID: <7qigbp$vbq$1@nnrp1.deja.com>

In article <hOYy3.7$tv5.2619_at_news.uswest.net>, "Larry Pettit" <larry.pettit_at_ps.net> wrote:
> Is there a way on Unix or NT to get process id of an executing query
that
> may be taking a long time and kill it from the client that started it
in the
> beginning?
>
>

Not sure about NT, but on Unix there is a way to find out process id of user process executing on server. Use the following query

select a.spid as pid, b.*
from sys.v_$process a, sys.v_$session b where a.addr=b.paddr;

To kill user process is the last resort. You better terminate it in Oracle Instance manager or manually:

alter system kill session <sid>, <serial>;

Hope this helps.

Nightwalker

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 01 1999 - 01:16:30 CDT