oracle 锁表sql

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 
where ao.object_id=lo.object_id and lo.session_id=sess.sid

alter system kill session '815,46584' --sid,serial

  

posted @ 2023-08-18 17:12  我没有出家  阅读(12)  评论(0编辑  收藏  举报