oracle 查看锁表语句

最新推荐文章于 2024-10-01 21:51:51 发布

车字辕

最新推荐文章于 2024-10-01 21:51:51 发布

阅读量92

点赞数

文章标签： oracle 数据库

原文链接：https://blog.csdn.net/LANZHENREN/article/details/125598848?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168844160116800213080370%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=168844160116800213080370&biz_id

版权

SELECT
	sess.sid,
	sess.serial#,
	lo.oracle_username, -- 登陆账号名称
	lo.os_user_name,    -- 登录电脑名称
	ao.object_name,     -- 被锁表名
	lo.locked_mode      -- 死锁级别
FROM
	v$locked_object lo,
	dba_objects ao,
	v$session sess 
WHERE
	ao.object_id = lo.object_id 
	AND lo.session_id = sess.sid
https://blog.csdn.net/LANZHENREN/article/details/125598848?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168844160116800213080370%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=168844160116800213080370&biz_id=0&spm=1018.2226.3001.4187