oracle 锁表查询 和 解锁

1. --查询谁锁定，谁等待
2. SELECT /*+ rule */
3. lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
4. o.owner,
5. o.object_name,
6. o.object_type,
7. s.sid,
8. s.serial#
9. FROM v$locked_object l, dba_objects o, v$session s
10. WHERE l.object_id = o.object_id
11. AND l.session_id = s.sid
12. ORDER BY o.object_id, xidusn DESC;
14. --释放session Sql 语法:
15. --alter system kill session 'sid, serial#'
16. --例子：
17. alter system kill session '379, 21132';