Re: Identify rows being locked

A copy of this was sent to luke.davies
<luke.daviesNOluSPAM_at_centers.co.uk.invalid> (if that email address didn't require changing) On Thu, 27 Jan 2000 05:26:59 -0800, you wrote:

>Thanks. But the utllockt.sql script just tells me about the tables
>that are locked and those people that may be waiting for locks. It
>only gives me table level information.
>I need to be able to identify the actual rows that are being locked and
>any given time.
>

you cannot. locks on rows are not stored outside of the table -- they are in effect stored on the block the row is on. You have to goto a row and try to lock it to see if it is locked.

>Cheers
>
>Luke
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 27 2000 - 09:00:29 CST