Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Cancel an Oracle Query Completely using SQL?
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1070573081.166590_at_yasure>...
> RK wrote:
> > Can someone help me?
> >
> > I am doing many SQL*Plus script queries within shell script batch jobs
> > on a UNIX box.
> >
> > I need a good query termination mechanism -- in some cases, it is for
> > testing, and I have to stop the queries because I know it is going
> > wrong -- how can I do this without damaging Oracle database? Any SQL
> > commands that I can use to terminate a running query?
> >
> > If more details, it is like the following:
> >
> > When it runs "sqlplus user/passwd @thescripts" from shell, shell
> > invokes a process for the "sqlplus" command, and the "sqlplus" command
> > process starts the Oracle query process. I know I can kill the first
> > process, but to kill the second one may take risk to cause Oracle
> > corrupt.
> >
> > How can I safely terminate the Oracle query process? Any SQL*Plus
> > command or any other UNIX ways?
> >
> > Thanks.
> >
> > RK
>
> Oracle: ALTER SYSTEM KILL SESSIN <sid, serial#>;
>
I guess only DBA can do that?
> Unix: kill -1 and if that doesn't work kill -9
> Windows: orakill
Are these two going to hurt Oracle or Oracle data anyway?
Thanks.
RK Received on Fri Dec 05 2003 - 10:55:51 CST