SELECT /*+ rule*/
a.sid, b.owner, object_name, object_type
FROM v$lock a, all_objects b
WHERE TYPE = 'TM'
and a.id1 = b.object_id;
SELECT sid,serial# FROM v$session WHERE sid = &sid;
alter system kill session '409,176';
SELECT /*+ rule*/
a.sid, b.owner, object_name, object_type
FROM v$lock a, all_objects b
WHERE TYPE = 'TM'
and a.id1 = b.object_id;
SELECT sid,serial# FROM v$session WHERE sid = &sid;
alter system kill session '409,176';