Re: Locking

From: Sheilah Scheurich <scheuric__at__sprynet_.com>
Date: 1997/09/29
Message-ID: <342FEBBC.32AE@_sprynet_.com>#1/1

Joe wrote:
>
> Hello,
> is it possible to find out which user has locked a row .
>
> Ciao,
> Huber Josef
>
> E-Mail: josef.huber_at_ennstal.atLook in the table called DBA_DML_LOCKS. It will give you the
information you need. Another place to look is in the V$SESSION table. However the information there will primarily tell you that a lock exists, and not the type.

-Sheilah Scheurich
DBA
to respond via email remove the underscores from my address. Received on Mon Sep 29 1997 - 00:00:00 CDT