`
xiaoshao
  • 浏览: 50080 次
社区版块
存档分类
最新评论

利用V$session，dba_objects和V$locked_Object找到谁给你的对象加了锁

阅读更多

V$locked_Object和dba_objects用object_id可以关联起来，找到dba_objects.object_name,

V$session的Sid和V$locked_object的session_id内联起来，可以从V$session中的machine找到机器名。进而找到机器。

使用alter system kill session 'sid,serial#'


select V$session.sid,V$session.machine,dba_objects.object_Name

from V$session.sid inner join V$locked_object on V$session.sid=V$locked_object.session_id

inner join dba_objects on dba_objects.object_id = V$locked_object.object_id;

分享到：
| Oracle中出现Ora-00054该怎么处理,V$locke ...
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    oracle 锁表查询

    先查看哪些表被锁住了 select b.username,b.sid,b.serial#,logon_...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 杀会话

    锁表问题解决

    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 ...

    oracle锁表该如何解决

    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 'sid,serial#'; 例如： alter system kill session ...

    Oracle 查找被锁的表并解锁

    1、查看被锁的表 select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b ...from v$locked_object a, v$session b , dba_objects o where a.session_id = b.sid an

    oracle查询锁表及解锁,修改表字段名与复制表结构和数据的方法

    select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id; 查看是哪个session引起的: select b.username,b.sid,b.serial#,logon_time

    锁表查看与解除

    锁表查看与解除 --查看锁表情况 select object_name,machine,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;

    orcale常用命令

    SQL> select pro.spid from v$session ses,v$process pro where ses.sid=21 and ses.paddr=pro.addr; 说明：21是某个连接的sid数 然后用 kill 命令杀此进程号。 五、SQL*PLUS使用 a、近入SQL*Plus $sqlplus ...

    oracle 不小心把表数据锁掉，sys查询被锁对象和解锁SQL语句

    一些ORACLE中的进程被杀掉后，状态被置为killed，但是... 　from v$locked_object l，dba_objects o ，v$session s 　where l.object_id　=　o.object_id and l.session_id=s.sid; 　2.下面的语句用来杀死一个进程：

    oracle.txt

    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 'sid,serial#'; alter system kill session '173,16112...

    ORACLE 如何查询被锁定表及如何解锁释放session

    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

    oracle处理锁表基本操作

    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 '543,9206';   如果杀不掉可以查这个来获取spid...

    Oracle 查询死锁并解锁的终极处理方法

    一些ORACLE中的进程被杀掉后，状态被置为”killed”，...from v$locked_object l,dba_objects o ,v$session s where l.object_id　=　o.object_id and l.session_id=s.sid; 2.下面的语句用来杀死一个进程： 代码如下

    oracle表被锁定的完美解决方法

    解决办法： ora-00031:session marked for kill处理oracle中杀不掉的锁一些ORACLE中的进程被杀掉后，状态被置为”killed”...from v$locked_object l,dba_objects o ,v$session s where l.object_id　=　o.object_id an

Magicbox
Global site tag (gtag.js) - Google Analytics