查看Oracle被锁的表

  ---------查看锁表的session------
 select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.sid 
 
 
 
 ---------查看锁表的session------
 SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID
  FROM ALL_OBJECTS A, V$LOCKED_OBJECT V
 WHERE A.OBJECT_ID = V.OBJECT_ID;
 
 
 --Kill session 'sid,serial#'; 
alter system kill session '674,1383';

有时需要DBA权限

1：查看被锁的表 

Sql代码  

1. SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID  
2.   FROM ALL_OBJECTS A, V$LOCKED_OBJECT V  
3. WHERE A.OBJECT_ID = V.OBJECT_ID   

2:查看锁 

Sql代码  

1. SELECT A.OBJECT_NAME, A.STATUS, V.SESSION_ID  
2.   FROM ALL_OBJECTS A, V$LOCKED_OBJECT V  
3. WHERE A.OBJECT_ID = V.OBJECT_ID   

2、杀死锁 

Sql代码  

1. --alter system kill session 'sid,serial#';  
2. alter system kill session '156,87';--查看表大小