Any way to identify specific rows that are locked?

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