3,491
社区成员
发帖
与我相关
我的任务
分享
SELECT a.username,
a.machine,
a.program,
a.sid,
a.serial#,
a.status,
c.piece,
c.sql_text
FROM v$session a, v$process b, v$sqltext c
WHERE b.spid = '7589'
AND b.addr = a.paddr
AND a.sql_address = c.address(+)
ORDER BY c.piece;
问下这个对吗? 然后又看见网上有查询当前正在执行的sql,sql语句如下 select a.program, b.spid, c.sql_text, c.SQL_ID
from v$session a, v$process b, v$sqlarea c
where a.paddr = b.addr
and a.sql_hash_value = c.hash_value
and a.username is not null;
但是查询到正在执行的sql并没有根据PID查到的sql语句。各位大神,这个到底是咋回事