Re: Finding username of row level lock holder on 7.2

From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1996/11/20
Message-ID: <32934A1B.3FEC_at_dt.com.hk>#1/1


rickhens_at_aol.com wrote:
>
> Does anyone know of a method of identifying the username of the holder of
> a row lock ? None of the V$ tables seem to contain the needed information
> to determine this. We are running version 7.2.
>
 

In Oracle 7.3 the work is very simple. We can query 'v$locked_object' to get the information.
IN oracle7.2, we have to select information from join of 'v$lock', 'v$session','dba_objects'.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049
Received on Wed Nov 20 1996 - 00:00:00 CET

Original text of this message