01 查看锁表的会话ID
>>select session_id from v$locked_object;
02 查看serial
>>select sid,serial#,username,osuser from v$session where sid = 12;
03 删除会话
>>alter system kill session '12,2716';
//12 代指 sid,2716 代指 serial
DB:oracle锁表,删除会话
最新推荐文章于 2024-07-25 15:13:11 发布