如何查看Oracle是否锁表

1.锁表查询的代码：

     select count(*) from v$locked_object;

     select * from v$locked_object;

 

2.查看哪个表被锁

    select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where

    a.object_id = b.object_id;

 

3.查看哪个session引起的

    select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id =

    b.sid order by b.logon_time;

 

4.杀掉对应进程 

    --1027  为sid      34 为serial#

    执行命令： alter system kill session ‘1027,34’；