selectc.owner,c.object_name,c.object_type,b.sid,b.serial#,b.status,b.osuser,b.machine
fromv$locked_object a ,v$session b,dba_objects c
whereb.sid = a.session_id
anda.object_id = c.object_id;
ALTER SYSTEM KILL SESSION '
ORACLE APPS TECHNICAL CONCEPTS
selectc.owner,c.object_name,c.object_type,b.sid,b.serial#,b.status,b.osuser,b.machine
fromv$locked_object a ,v$session b,dba_objects c
whereb.sid = a.session_id
anda.object_id = c.object_id;
ALTER SYSTEM KILL SESSION '