Re: which row is locked?

From: <steveee_ca_at_my-deja.com>
Date: Mon, 11 Dec 2000 16:51:07 GMT
Message-ID: <9130lo$h2r$1@nnrp1.deja.com>

Hi David,

If you're trying to find which row is causing contention, you can use V$SESSION..look at these columns:

 ROW_WAIT_OBJ#
 ROW_WAIT_FILE#
 ROW_WAIT_BLOCK#
 ROW_WAIT_ROW#

I hope this helps.

Steve

In article <912q5k$5in$1_at_mailint03.im.hou.compaq.com>, "david spaisman" <david.spaisman_at_compaq.com> wrote:
> Hello:
>
> The application I am working with runs on Oracle 8.1.6.00.
>
> I have seen several scripts which can tell me which object is locked
by
> user. What would be more helpful would be:
>
> how can I tell which row is locked by a particular process?
>
> Does any one know how I can tell which row for an object is locked by
which
> user?
>
> Any information you can provide will be greatly appreciated. Thanks.
>
> David Spaisman
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 11 2000 - 10:51:07 CST