Re: How to delete a lock

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 08 Aug 2006 13:01:45 -0700
Message-ID: <1155067304.963698@bubbleator.drizzle.com>

dn.perl_at_gmail.com wrote:
> 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.

On the Killing Sessions page I have demonstrated three different ways to kill a session. If you are on UNIX or Linux I'd use kill -9 with malice and aforethought.

If on Windows try orakill.

If that doesn't do it then shutdown abort.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Aug 08 2006 - 15:01:45 CDT