Re: Finding username of row level lock holder on 7.2

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.
>
> Thanks in advance,
>
> Rick Hensley
Rick,

select s.* from v$lock l, v$session s
where s.sid = l.sid
and l.lmode in ( 'TX','RX' ) -- check for the DBA manuals for the different values of lock modes.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.