查询持有锁的会话和请求锁的会话之间的冲突关系

最新推荐文章于 2025-12-11 15:19:37 发布

原创最新推荐文章于 2025-12-11 15:19:37 发布 · 139 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database

gbase8s 同时被 3 个专栏收录

148 篇文章

订阅专栏

xigemaDB

77 篇文章

订阅专栏

SinoDB

52 篇文章

订阅专栏

本文探讨了如何通过SQL查询语句，利用sysscblsta、sysrstcbb等表之间的联接，优化数据检索。涉及owner_sid、waiter_sid关联及特定flag条件筛选，同时强调了部分关键字段的哈希编码。

select 
       e.sid as owner_sid,e.username as owner,
       hex(c.partnum) as partnum,hex(c.rowidr) as rowid,
       a.sid as waiter_sid,a.username as waiter
from 
       sysscblst a, sysrstcb b, syslcktab c,systxptab d, sysrstcb e
where 
       a.address=b.scb and b.lkwait=c.address and c.owner=d.address 
       and d.owner=e.address and bitval(b.flags,'0x80000')=1
       and bitval(b.flags, '0x4')=1
order by 2,3,4