Oracle通过主机top命令查看具体sql

select c.sql_text
from gv$session a,gv$process b,gv$sqltext c
where a.paddr = b.addr and a.sql_address = c.address and b.spid =  '&spid'
order by piece ASC;

--将&spid换成具体进程的pid即可