【转】从spid查询sql
-
msdnchina
2011-11-01 17:39:04
-
数据库开发技术
-
原创
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@]