How to Cancel an Oracle Query Completely using SQL?

From: RK <rekaben_at_yahoo.com>
Date: 4 Dec 2003 09:39:09 -0800
Message-ID: <239f1935.0312040939.5e41d84a@posting.google.com>

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 Received on Thu Dec 04 2003 - 11:39:09 CST