Oracle 版本 11gR2
1) 首先把DB的spfile参数的 audit_trail 调成 DB_EXTENDED , 然后重启Oracle DB (用DB Control的web界面挺方便的)
2) 使用下面的SQL
select TO_CHAR(extended_timestamp, 'DD-MON HH24:MI:SS') , sql_text from DBA_AUDIT_TRAIL a1 , v$session s1 where a1.sessionid = s1.audsid and s1.program like 'JDBC%' and a1.username='EPM' and a1.owner='EPM' ORDER by extended_timestamp desc; /