本文介绍了一个具体的SQL查询示例，用于从Oracle数据库的动态性能视图中获取活动会话的信息。此查询通过连接gv$session和gv$sqltext_with_newlines视图来展示特定用户的活跃SQL会话详情，并按登录时间和会话ID进行排序。
SELECT (SELECT listagg(b.sql_text, '') within GROUP(ORDER BY b.piece)
FROM gv$sqltext_with_newlines b
WHERE b.address = hextoraw(a.sql_address)
AND b.hash_value = a.sql_hash_value) sql_text,
a.*
FROM gv$session a
WHERE a.username IN ('CCM', 'CCMAPPS')
AND a.status = 'ACTIVE'
ORDER BY a.logon_time, a.sid
FROM gv$sqltext_with_newlines b
WHERE b.address = hextoraw(a.sql_address)
AND b.hash_value = a.sql_hash_value) sql_text,
a.*
FROM gv$session a
WHERE a.username IN ('CCM', 'CCMAPPS')
AND a.status = 'ACTIVE'
ORDER BY a.logon_time, a.sid
扫一扫
6084
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
