oracle查询哪些表被谁锁住了

select sess.sid, 
   sess.serial#, 
   lo.oracle_username, 
   lo.os_user_name, 
   ao.object_name, 
   lo.locked_mode,
sess.LOGON_TIME,
sess.machine
   from v$locked_object lo, 
   dba_objects ao, 
   v$session sess 

where ao.object_id = lo.object_id and lo.session_id = sess.sid order by sess.logon_time desc

查出原因后

 --解除数据库中被锁住的表(SID,SERIAL)

alter system kill session '对应的SID,对应的SERIAL;

参考链接：http://blog.csdn.net/karali/article/details/10439521