locking problems lock_id1 utllockt

From: Ronald <ronr_at_wxs.nl>
Date: Thu, 27 Aug 1998 20:20:16 +0200
Message-ID: <01HW.B20B7000000232D602447420@news.wxs.nl>

Hi,

oracle 7.3.4.2 on aix 4.1.5

in one instance we have quite some locking problems. Using utllockt.sql I could track down most of them. The table-locks are gone now but we still have locking, even deadlocks.

What I am wondering now is: how do I find out what db object is involved in a lock ? utllockt.sql gives a list containing LOCK_ID1 and LOCK_ID2. How can I use these to get the table/row of whatever that it is that's locked. I think it's a pointer to some temporary structure.

Since the locks sometimes stay for 5 to 30 minutes (?!) I have plenty time to run some queries. One of the possibillities is a lock on the transaction tables.

Any help is very much appreciated.

--
Ronald

---

mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998) http://www.maccentral.com/news/9804/migration.shtml (forward migration home) Received on Thu Aug 27 1998 - 13:20:16 CDT