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 -> Re: Who has my row locked?

Re: Who has my row locked?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 12 Jul 1998 09:16:56 GMT
Message-ID: <01bdad75$4e0bffb0$0300a8c0@WORKSTATION> 






If you are looking at v$lock WHILST trying to lock the row (i.e.
using


a second session to track down the problem), the following may help:



The TX lock that your waiting session holds will be a request in
exclusive


mode (request  = 6, but lmode=0) there will be another TX lock with
the 


same id1 and id2 with lmode = 6 and request = 0 - that row will be
the


one you are waiting on



Jonathan Lewis

Received on Sun Jul 12 1998 - 04:16:56 CDT












Original text of this message













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