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: find what user has a row locked for update??

Re: find what user has a row locked for update??

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: 20 May 2005 20:07:40 -0700
Message-ID: <1116644860.847440.78550@g49g2000cwa.googlegroups.com>


Jeff:

It would be quite difficult to get the details without block dumps as the lock information is kept at the data block level and oracle does not maintain any external record (lock table) for the TX locks. But if the session is waiting for the row, which is already locked by some other user, sometimes that information is visible in V$SESSION (FILE#, BLOCK# and ROW# for ROW_WAITs)

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ Received on Fri May 20 2005 - 22:07:40 CDT

Original text of this message

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