select * from v$sessions where trx_id in (select trx_id from V$LOCK) and user_name = '用户名称' order by create_time desc;
sp_close_session(上面语句查询到的sess_id);