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
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 3049Received on Wed Nov 20 1996 - 00:00:00 CET