ORACLE查询锁表与解锁

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;
  
  -------------------------------------
select s.username,
       s.sid,
       s.status,
       sq.sql_text sql_text,
       t.USED_UREC Records,
       t.USED_UBLK Blocks,
       t.USED_UBLK *
       (select value from v$parameter where name = 'db_block_size') / 1024 KBytes
  from v$transaction t, v$session s, v$sql sq
 where t.addr = s.taddr
   and s.PREV_SQL_ID = sq.sql_id;
----------------------------------------
SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='2909'; 
-------------------------------------------
ALTER SYSTEM KILL SESSION '2909,14130';