通过session查到他执行的SQL?
SELECT T.SPID, T1.SID, T1.SERIAL#, T2.SQL_FULLTEXT
FROM V$PROCESS T, V$SESSION T1, V$SQL T2
WHERE T.ADDR = T1.PADDR
AND T1.SQL_ADDRESS = T2.ADDRESS
或者
select S.sql_text from v$session se ,v$sqlarea s where se.sql_hash_value=s.hash_value and se.username='SCOTT';
