if the session is in 'KILLED' status it is rolling back the transaction.
you have to wait for this to finish. it can take a while.
>
> From: "Siddharth Haldankar" <[EMAIL PROTECTED]>
> Date: 2003/07/17 Thu AM 06:24:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: unlocking objects >
>
> Hi Gurus,
>
>
>
> One of my object is locked. How do I unlock that object explicitly ?
>
> The session is already killed, but still the object appears in locked
> status.
>
>
>
> Thanks in advance
>
>
>
> With Warm Regards
>
> _____
>
> Siddharth Haldankar
>
> Cisco Systems Inc. ODC
>
> Zensar Technologies Ltd.
>
> # : 4128374
>
> [EMAIL PROTECTED]
>
> [EMAIL PROTECTED]
>
>
>
>
>
Title: RE: are fast refreshes really fast?
Hi Gurus,
One of my object is locked. How do I
unlock that object explicitly ?
The session is already killed, but still
the object appears in locked status.
Thanks in advance
With Warm Regards
Siddharth
Haldankar
Cisco Systems Inc. ODC
Zensar Technologies
Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
|