select concat('call sp_close_session(',SESS_ID,');')
from (
select distinct c.SESS_ID
from v$lock a
join sysobjects b on b.ID=a.TABLE_ID
join v$sessions c on a.TRX_ID=c.TRX_ID and b.name='表名');
select concat('call sp_close_session(',SESS_ID,');')
from (
select distinct c.SESS_ID
from v$lock a
join sysobjects b on b.ID=a.TABLE_ID
join v$sessions c on a.TRX_ID=c.TRX_ID and b.name='表名');