读书人

Oracle解锁下令

发布时间: 2012-07-05 07:59:18 作者: rapoo

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.sidobject_id And a.session_id = c.sid 查看锁表的会话id,执行 alter system kill session 'sid,serial#' immediate; 杀掉进程中的会话

读书人网 >其他数据库

热点推荐