Re: Oracle RDBMS 7. Monitoring Row Locks
From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1996/02/06
Message-ID: <DMDB0G.1EL_at_twisto.eng.hou.compaq.com>#1/1
Date: 1996/02/06
Message-ID: <DMDB0G.1EL_at_twisto.eng.hou.compaq.com>#1/1
Dean,
Try this little select statement. I think it has what you want.
select c.username,a.type,a.lmode,b.object_name,b.object_type
from v$lock a, all_objects b, v$session c
where a.id1 = b.object_id and
a.sid = c.sid;
The v$lock view has all the lock information on the database. The all_object view list the objects you have access to. The v$session view lists the current sessions on the instance. Please note the first six or so, depending on the instance setup, are the Oracle background processes.
This should get you going.
D. Kim Hughes
Managing Consultant
DRT Systems
Houston, TX
(713)868-5537
Received on Tue Feb 06 1996 - 00:00:00 CET