Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping run-away Oracle queries
I might be wrong but I think Oracle removed the control-c option from
SQL*Plus in the 8 and 8i versions. I can't imagine why.
Van
<peterjoh_at_my-deja.com> wrote in message news:813ufr$srl$1_at_nnrp1.deja.com...
> Hi all.
> Is it possible to stop 'run-away' queries on Oracle 8.0.5?
>
> We are running netscape enterprise server, on Solaris, talking to
> Oracle, and sometimes we create stupid queries that take forever
> (almost) to complete. We need to abort these queries and free up the
> oracle server for a new request.
>
> It seems that the sqlplus interface allows a Control/C sequence to
> somehow stop the query. Does anyone know how it does this?
>
> We access Oracle through both the netscape interface and also through
> ProC interface.
>
> thanks for any help,
> PeterJoh
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 19 1999 - 18:22:14 CST