数据库锁表万能语句(ORACLE数据库表解锁record is locked by another user)
1.查锁
select t2.username,t2.sid,t2.serial#,t2.logon_time from vlockedobjectt1,vlocked_object t1,vlockedobjectt1,vsession t2 where t1.session_id=t2.sid order by t2.logon_time;
2.解锁
–alter system kill s...
原创
2020-04-02 09:40:34 ·
250 阅读 ·
0 评论