oracle锁表解锁

    xiaoxiao2022-07-04  157

    --锁表查询SQL  SELECT object_name, machine, s.sid, s.serial#  FROM gv$locked_object l, dba_objects o, gv$session s  WHERE l.object_id = o.object_id  AND l.session_id = s.sid; 

    --释放SESSION SQL: 

     alter system kill session '1000,5053' immediate;

    最新回复(0)