oracle锁表查询与解锁脚本|oracle解锁脚本|oracle锁表

SELECT
  b.owner table_owner,
  b.object_name,
  c.username,
  c.sid,
  c.serial#,
  'alter system kill session '''||c.sid||','||c.serial#||''';'  AS commond
  FROM
         v$locked_object a,
         dba_objects b,
         v$session c
  WHERE a.object_id = b.object_id
        AND c.sid = a.session_id;