1.找出谁锁定了什么
SQL:
- SELECT v2.username,v2.sid,v2.serial#,v2.logon_time From v$locked_object v1,v$session v2 Where v1.session_id=v2.sid order by v2.logon_time
2.结束掉这个session
SQL:
- ALTER system KILL session 'sid,serial#';