Oracle 解决锁表的sql语句

--查看锁表
SELECT l.session_id      sid,
       s.serial#,
       l.locked_mode     锁模式,
       l.oracle_username 登录用户,
       l.os_user_name    登录机器用户名,
       s.machine         机器名,
       s.terminal        终端用户名,
       o.object_name     被锁对象名,
       s.logon_time      登录数据库时间
  FROM v$locked_object l, all_objects o, v$session s
 WHERE l.object_id = o.object_id
   AND l.session_id = s.sid
 ORDER BY sid, s.serial#;
 
 --解锁,引号中'sid,serial'根据查看锁表结果来填写
 alter system kill session '21,15';