set pagesize 2000
col sess format a20
break on id1 skip 1
SELECT DECODE(request,0,'Holder: ',' Waiter: ')||inst_id || ':' || sid sess,
id1, id2, lmode, request, type, ctime
FROM GV$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0)
ORDER BY id1, request;
col sess format a20
break on id1 skip 1
SELECT DECODE(request,0,'Holder: ',' Waiter: ')||inst_id || ':' || sid sess,
id1, id2, lmode, request, type, ctime
FROM GV$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0)
ORDER BY id1, request;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7597006/viewspace-606514/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查询数据库登陆用户的当前环境！
下一篇：
没有了~
请登录后发表评论
登录
全部评论
