alter table "XF"."XF_RECE_DOC" modify "HOT_WORD" VARCHAR(30); --锁超时
-- 查看锁信息
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(sess_id)
alter table "XF"."XF_RECE_DOC" modify "HOT_WORD" VARCHAR(30); --锁超时
-- 查看锁信息
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(sess_id)