oracle 表锁

xiaoxiao2021-02-28  126

select sess.sid,         sess.serial#,         lo.oracle_username,         lo.os_user_name,         ao.object_name,         lo.locked_mode    from v$locked_object lo, dba_objects ao, v$session sess, v$process p  where ao.object_id = lo.object_id     and lo.session_id = sess.sid;        alter system kill session '769,69'; 
转载请注明原文地址: https://www.6miu.com/read-49678.html

最新回复(0)