select 'exec sys.kill_session('||a.SID||','||a.SERIAL#||');',
a.sid,
a.serial#,
c.spid,
a.username,
d.OBJEXT_NAME,
a.status,
a.program,
b.id1,
b.id2,
b.ctime,
from v$session a,v#lock b,v$process c,all_objects d
where b.id1=d.object_id
and a.sid=b.sid
and a.paddr=c.addr
and b.block=0
and d.OBJEXT_NAME='&table_name';
--普通用户使用命令模式执行
exec sys.kill_session(v_sid,v_serial);