Re: How to delete a lock

DA Morgan wrote:
>
>
> Go to www.psoug.org and click on Morgan's Library.
> Scroll down to Killing Sessions.
>
> But before you do anything else run this:
>
> SELECT status
> FROM gv$session
> WHERE sid = <sid>
> AND serial# = <serial#>;
>
> What is the status?
>

status = 'ACTIVE' .

I tried to drop the user which was locking the table to see what message I get. One function, which looks pretty harmless, was supposed to be the culprit. IIRC the message talked about a locked function, but I am/was not sure whether a function can be locked.

At any rate, I needed to kill the session quickly, and move on, since I had got badly stuck. I will revisit the thread later to study it in greater detail.

Thanks to everybody who responded to my query. Received on Tue Aug 08 2006 - 13:46:09 CDT