1. 首页
  2. 数据库
  3. Oracle
  4. oracle锁表查询

oracle锁表查询

上传者: 2019-02-23 12:34:10上传 TXT文件 3.74KB 热度 63次
先查看哪些表被锁住了 select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid and sid in( select a.SESSION_ID from v$locked_object a,dba_objects b where b.object_id = a.object_id and object_name ='HDM_COMPLETED_RATE') order by b.logon_time 杀会话
用户评论