oracle 根据pid查询出正在执行的执行语句

最新推荐文章于 2023-07-07 10:11:49 发布

Borntodieee

最新推荐文章于 2023-07-07 10:11:49 发布

阅读量743

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/Borntodieee/article/details/90401327

版权

oracle 专栏收录该内容

34 篇文章 0 订阅

订阅专栏

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