Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL for lcoked sessios
- Thread starter Thiko
- Start date
SELECT s.username, l.type, o.object_name,
DECODE(l.lmode, 2, 'Row-S(SS)',
3,'Row-X(SX)',
4, 'Share',
5, 'S/Row-X(SSX)',
6, 'Exclusive', 'Other' Mode_Held,
FROM dba_objects o, v$session s, v$lock l
WHERE s.sid = l.sid
AND o.object_id = l.id1
AND s.username is not null;
DECODE(l.lmode, 2, 'Row-S(SS)',
3,'Row-X(SX)',
4, 'Share',
5, 'S/Row-X(SSX)',
6, 'Exclusive', 'Other' Mode_Held,
FROM dba_objects o, v$session s, v$lock l
WHERE s.sid = l.sid
AND o.object_id = l.id1
AND s.username is not null;
- Thread starter
- #3
- Status
Similar threads
