Oracle解除表的锁定

select
    object_name,
    oracle_username, 
    s.sid,
    s.serial#
from
    v$locked_object   l,
    dba_objects       o,
    v$session         s
where
    l.object_id = o.object_id 
and
    l.session_id = s.sid;
 

alter system kill session '96,36261'  immediate;

  

posted @ 2020-06-23 07:26  初入门径  阅读(114)  评论(0)    收藏  举报