- --查询谁锁定,谁等待
- SELECT /*+ rule */
- lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
- o.owner,
- o.object_name,
- o.object_type,
- s.sid,
- s.serial#
- FROM v$locked_object l, dba_objects o, v$session s
- WHERE l.object_id = o.object_id
- AND l.session_id = s.sid
- ORDER BY o.object_id, xidusn DESC;
- --释放session Sql 语法:
- --alter system kill session 'sid, serial#'
- --例子:
- alter system kill session '379, 21132';
oracle 锁表查询 和 解锁
最新推荐文章于 2024-07-01 12:46:23 发布