Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Any way to identify specific rows that are locked?

Any way to identify specific rows that are locked?

From: Keith D Gregory <keith_at_inconcert.com>
Date: Wed, 12 May 1999 11:30:04 -0400
Message-ID: <37399E7B.AB71E17A@inconcert.com>


We are experiencing a problem with distributed transactions; when one client crashes, it apparently holds locks that the others (not in the same transaction) need to acquire. The only problem is that there's no reason for these clients to be waiting on one another.

Looking at V$LOCK, we can see what appear to be shared row locks, which is to be expected. However, a shared row lock shouldn't block the other operations.

So, we're trying to find out which locks are being held and requested, at a row level, to try and identfy what's happening.

Seems there should be a view to do this somewhere, but it doesn't appear to be documented. Anyone know of one?

-kdg Received on Wed May 12 1999 - 10:30:04 CDT

Original text of this message

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