I may be naive, but I don't think Oracle is going to be hurt if you use
'kill' on a process doing a query.
"RK" <rekaben_at_yahoo.com> wrote in message
news:239f1935.0312040939.5e41d84a_at_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 - 13:58:46 CST
