select t.SESSION_ID,s.SERIAL#,t.PROCESS,t.ORACLE_USERNAME,o.object_name from v$locked_object t, v$session s,dba_objects o where t.SESSION_ID=s.SID and t.OBJECT_ID=o.object_id;
Alter system kill session 'sid,serial#';
select t.SESSION_ID,s.SERIAL#,t.PROCESS,t.ORACLE_USERNAME,o.object_name from v$locked_object t, v$session s,dba_objects o where t.SESSION_ID=s.SID and t.OBJECT_ID=o.object_id;
Alter system kill session 'sid,serial#';