Re: Row-locking on "FOR UPDATE" processes - Oracle support plus read.
From: John Bell <jbellb_at_cix.compulink.co.uk>
Date: Thu, 15 Dec 1994 21:24:19 GMT
Message-ID: <D0vFGK.JBG_at_cix.compulink.co.uk>
Date: Thu, 15 Dec 1994 21:24:19 GMT
Message-ID: <D0vFGK.JBG_at_cix.compulink.co.uk>
This is a real problem if you need to know who is locking the exact row that you are after, however, if your application will settle for finding out who is holding ANY lock on the table in question, then this can be achieved by querying the V$LOCK,V$ACCESS,V$PROCESS and V$RESOURCE dictionary views (See DBA Manual).
hope this helps
Howi Received on Thu Dec 15 1994 - 22:24:19 CET