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_at_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 Sat May 21 2005 - 05:07:40 CEST

This message: [ Message body ]
Next message: DA Morgan: "Re: find what user has a row locked for update??"
Previous message: IANAL_VISTA: "Re: multiple passwords for a user"
In reply to: jeffchirco_at_gmail.com: "find what user has a row locked for update??"
Next in thread: DA Morgan: "Re: find what user has a row locked for update??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message