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 -> Strange enqueue problem (even after it is killed!)

Strange enqueue problem (even after it is killed!)

From: <robertchung0909_at_my-deja.com>
Date: Sun, 20 Feb 2000 01:11:59 GMT
Message-ID: <88nf0u$gt8$1@nnrp1.deja.com>

I had one session that locked almost every row in a table. About 10 minutes ago I killed it. Now, I am trying to lock the same rows, only to be put on hold waiting for enqueue lock to be resolved. I took a look at the output of utllockt.sql and it clearly showed my new session is waiting for enqueue lock to be released from . . . the session that I killed more than 10 minutes ago. By checking locking session's SID and looking at v$session, I could verify that it indeed is the killed session. What the heck is Oracle doing letting killed session hold enqueue lock? Is there something that I can do? 'alter system kill session' would not do any good because I've already killed it long time ago. Thank you in advance.

PS: by the way, Oracle's version is 8.0.5 running on Windows NT (my boss wanted NT. I only take orders.)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Feb 19 2000 - 19:11:59 CST

Original text of this message

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