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