select b.owner,b.object_name, a.session_id, a.OS_USER_NAME, a.locked_mode from v$locked_object a, dba_objects b where b.object_id = a.object_id; select * from v$locked_object;
oracle查看锁表语句
最新推荐文章于 2024-07-24 20:04:27 发布
select b.owner,b.object_name, a.session_id, a.OS_USER_NAME, a.locked_mode from v$locked_object a, dba_objects b where b.object_id = a.object_id; select * from v$locked_object;