oracle查询是否锁表以及解锁语句

--锁表语句

select t2.username,
       t2.sid,
       t2.serial#,
       t3.object_name,
       t2.OSUSER,
       t2.MACHINE,
       t2.PROGRAM,
       t2.LOGON_TIME,
       t2.COMMAND,
       t2.LOCKWAIT,
       t2.SADDR,
       t2.PADDR,
       t2.TADDR,
       t2.SQL_ADDRESS,
       t1.LOCKED_MODE
  from v$locked_object t1, v$session t2, dba_objects t3
 where t1.session_id = t2.sid
   and t1.object_id = t3.object_id
 order by t2.logon_time;   --查询锁表情况 

备注说明
OWNER ：数据表的所有者用户
OBJECT_NAME： 被锁住的表名
SESSION_ID： 会话ID
LOCKED_MODE： 锁级别
锁级别分为6级：
1级锁有：Select 2级锁有：Select for update,Lock For Update,Lock Row Share
3级锁有：Insert, Update, Delete, Lock Row Exclusive
4级锁有：Create Index,Lock Share
5级锁有：Lock Share Row Exclusive
6级锁有：Alter table, Drop table, Drop Index, Truncate table, Lock Exclusive

--杀掉对应的进程来解锁

alter system kill session '1025,41';

1025为sid,41为serial#

此操作需要有管理员的权限

如果出现ora-00031错误，需要alter system kill session '1025,41' immediate;