Re: Need of kill query
Why don't you write a simple awk script that grabs the output of
onstat -g sql and issues an onmode -z for the sid's matching thepattern you want? This way you're not going into the database
at all and is much faster.
Arun
sanjeev sagar wrote:
> Hey Guy's,
>
> I am in need of one kill query which should do the
> following
>
> KILL ALL SELECT QUERY CONNECTED TO A SPECIFIC
> DATABASE OF A SPECIFIC INSTANCE.
>
<snip>