-- v$lock 锁信息 sysobjects 表信息 v$session 会话信息
select a.*,b.NAME,c.SESS_ID from v$lock a
left join sysobjects b on b.ID=a.TABLE_ID
left join v$sessions c on a.TRX_ID=c.TRX_ID;
sp_close_session('1139675440');
-- v$lock 锁信息 sysobjects 表信息 v$session 会话信息
select a.*,b.NAME,c.SESS_ID from v$lock a
left join sysobjects b on b.ID=a.TABLE_ID
left join v$sessions c on a.TRX_ID=c.TRX_ID;
sp_close_session('1139675440');