【转】从spid查询sql

SELECT sql_text FROM v$sqltext a WHERE a.hash_value = (SELECT sql_hash_value FROM v$session b WHERE b.SID =( select s.sid from v$session s,v$process p where s.paddr=p.addr and p.spid='31903')) ORDER BY piece ASC[@more@]
请使用浏览器的分享功能分享到微信等