Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TErminating SQL stmt

Re: TErminating SQL stmt

From: Andrew Protasov <protasov_at_percombank.kiev.ua>
Date: 1998/06/09
Message-ID: <6liqea$2n8@post.percombank.kiev.ua>#1/1

Hi Jason,

You don't need sys password but only DBA account.

Andrew Protasov

Jason Selby wrote in message <357C0B24.668152E1_at_cams.co.uk>...
>
>
>Umar FArooq wrote:
>
>> Hi!
>> Is there a way to terminate an SQL statement which is taking too long to
>> execute?
>>
>> Thx.
>>
>> Umar
>> CresSoft, Lahore, Pakistan
>> umar.farooq_at_cressoft.com.pk
>
> You need to kill the session in the session manager from another client.
>You'll need to know the sys password.
>
>HTH
>
>Jason
>
>
Received on Tue Jun 09 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US