Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Strange enqueue problem (even after it is killed!)
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