/* ORACLE */ :::Blocking session SELECT vl.sid, vl.TYPE, | SergeyGurin

/*
ORACLE
*/

:::Blocking session
SELECT vl.sid,
vl.TYPE,
vl.lmode,
vl.ctime,
vl.block,
vs.username,
vs.lockwait,
vs.status,
vs.schemaname,
vs.osuser,
vs.machine,
vs.terminal,
vs.program,
vs.sql_id,
vs.prev_sql_id,
VS.MODULE,
O.OBJECT_NAME
FROM v$lock vl,
v$session vs,
v$locked_object l,
dba_objects o
WHERE vl.TYPE = 'TX'
AND vl.sid = vs.sid
AND vs.username = USER
AND vl.SID = L.SESSION_ID
AND l.object_id = o.object_id;