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
扫一扫
657
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
