Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TErminating SQL stmt
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