oracle查询及解决锁表问题

1.查询所有被锁定的表

   SELECT object_name, machine, s.sid, s.serial#
      FROM gv$locked_object l, dba_objects o, gv$session s
     WHERE l.object_id　 = o.object_id
       AND l.session_id = s.sid;

2.对相应表解锁

--释放SESSION SQL: 
--alter system kill session 'sid, serial#'; 
ALTER system kill session '123, 4567'; 

–以下几个为相关表

SELECT * FROM v$lock;
SELECT * FROM v$sqlarea;
SELECT * FROM v$session;
SELECT * FROM v$process ;
SELECT * FROM v$locked_object;
SELECT * FROM all_objects;
SELECT * FROM v$session_wait;