本文深入探讨了SQL查询在数据库交互中的应用，通过解析V$process、V$session、V$locked_Object和All_Objects表，展示了如何构建SQL查询以获取特定进程、会话、锁定对象和对象名称的相关信息。
Select p.Spid,
c.Object_Name,
b.Session_Id,
b.Oracle_Username,
b.Os_User_Name
From V$process p, V$session a, V$locked_Object b, All_Objects c
Where p.Addr = a.Paddr
And a.Process = b.Process
And c.Object_Id = b.Object_Id
c.Object_Name,
b.Session_Id,
b.Oracle_Username,
b.Os_User_Name
From V$process p, V$session a, V$locked_Object b, All_Objects c
Where p.Addr = a.Paddr
And a.Process = b.Process
And c.Object_Id = b.Object_Id
扫一扫
940
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
