| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping run-away Oracle queries
Van Messner wrote:
>
> 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.
You can still do File-Cancel (on gui) but I agree - sometimes you cannot get to the menu to kill it.
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Nov 19 1999 - 10:43:01 CST
 |
 |