根据PID查找对应正在执行的sql语句
SELECT sql_text
FROM v$sqltext
a
WHERE a.hash_value
= ( SELECT sql_hash_value
FROM v$session
b, v$process c
WHERE b.paddr
= c.addr
AND c.spid
= PID)
ORDER BY piece ASC ;
根据PID查找正在执行的进程
SELECT s.username,
s.sid, s.serial#
FROM v$session
s, v$process p
WHERE s.paddr
= p.addr
AND p.spid
= PID
