本文介绍了一种通过SQL查询来获取特定进程ID (PID) 的SQL执行信息的方法。使用Oracle数据库的动态性能视图v$sqltext、v$session 和 v$process，可以详细地追踪和分析SQL语句的执行情况。
SELECT sql_text
FROM v$sqltext a
WHERE (a.hash_value, a.address) IN
(SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value),
DECODE(sql_hash_value, 0, prev_sql_addr, sql_address)
FROM v$session b
WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = '$pid))
ORDER BY piece ASC
FROM v$sqltext a
WHERE (a.hash_value, a.address) IN
(SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value),
DECODE(sql_hash_value, 0, prev_sql_addr, sql_address)
FROM v$session b
WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = '$pid))
ORDER BY piece ASC
扫一扫
1042
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
