Re: how od you stop a long running command

In article <4gYo5.649$GX5.187704_at_dfiatx1-snr1.gtei.net>,   "LPCTSTR" <jobob_at_aol.com> wrote:
> Hello,
>
> Im fairly new to Oracle and SQL plus. How do you stop a long running
> command. Lets say you accidently forgot to put the where clause on a
 select
> statement using a large table, how can you kill that command after it
 has
> started ?
>
> Randal
> Dallas,TX
>

From sqlplus, from the same session, you can normally issue a control- c, interrupt, to cancel the running query.

If <ctl-c> is trapped by your OS environment settings or otherwise fails you can open a second session, use it to identify your first session in v$session and issue an alter system kill session 'sid,serial#' command to terminate and rollback your first session.

Alternately you can kill the Oracle session server background process at the OS level. On VMS this is recommended (per installation manual for 7.3.4) over the alter system command.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.