Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping run-away Oracle queries

Re: Stopping run-away Oracle queries

From: Van Messner <vmessner_at_netaxis.com>
Date: Fri, 19 Nov 1999 19:22:14 -0500
Message-ID: <IRlZ3.29291$YI2.1361099@typ11.nn.bcandid.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US