SELECT \/*+ rule *\/ s.username,<\/p>\n\n\n\n
decode(l.type,’TM’,’TABLE LOCK’,<\/p>\n\n\n\n
‘TX’,’ROW LOCK’,<\/p>\n\n\n\n
NULL) LOCK_LEVEL,<\/p>\n\n\n\n
o.owner,o.object_name,o.object_type,<\/p>\n\n\n\n
s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser<\/p>\n\n\n\n
FROM v$session s,v$lock l,dba_objects o<\/p>\n\n\n\n
WHERE l.sid = s.sid<\/p>\n\n\n\n
AND l.id1 = o.object_id(+)<\/p>\n\n\n\n
AND s.username is NOT Null;<\/p>\n\n\n\n
— alter system kill session’389,3523′;<\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT \/*+ rule *\/ s.username, decode(l.type,R … <\/p>\n