Oracle解锁命令
Oracle解锁命令
Oracle解锁命令:
- 执行
- select b.owner,
- b.object_name,
- a.session_id,
- a.locked_mode,
- c.serial#,
- c.sid || ',' || c.serial#
- from v$locked_object a, dba_objects b, v$session c
- where b.object_id = a.object_id
- And a.session_id = c.sid
- object_id
- And a.session_id = c.sid
- 查看锁表的会话id,
- 执行 alter system kill session 'sid,serial#' immediate; 杀掉进程中的会话
评论暂时关闭