oracle根据sql进程号查找对应sql

top

 

select  t3.sql_text from v$process t1 inner join v$session t2 on t1.addr = t2.paddr
inner join v$sql t3 on t2.sql_id =t3.sql_id where t1.spid = 27087;

posted @ 2021-08-13 13:49  up~up  阅读(547)  评论(0)    收藏  举报