根据 pid 找到 SQL

SELECT addr FROM vprocess c WHERE c.spid = 30546 ;

SELECT DECODE (sql_hash_value,
0, prev_hash_value,
sql_hash_value
),
DECODE (sql_hash_value, 0, prev_sql_addr, sql_address)
FROM vsession b
WHERE b.paddr = ‘000000007F4ABE40’;

select a.sql_text,a.sql_id From v$sqltext a where a.hash_value=’0 ‘ and a.address=’00’ order by piece ;