Oracle解决表锁定的问题

来源：宝玛科技网

1. 通过v$session，v$locked_object查看谁锁定了资源 select t1.sid, t1.serial#, t1.username, t1.logon_time from v$session t

1. 通过v$session，v$locked_object查看谁锁定了资源

select t1.sid, t1.serial#, t1.username, t1.logon_time

from v$session t1 , v$locked_object t2

where t1.sid = t2.session_id

order by t1.logon_time

2. 通过alter system kill session 'sid, serial#'把session kill掉

alter system kill session '6,8'

，

违法及侵权请联系：TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务