Re: How to capture SQL_TEXT of queries?

From: George H. Claborn <claborn_at_bit-net.com>
Date: 1997/04/11
Message-ID: <334d832f.3926991@news.bit-net.com>#1/1

Here's another thought:
Do an AUDIT SELECT TABLE; which will log an audit record in DBA_AUDIT_TRAIL for all selects against all tables, views and snapshots. Or, if that's too expensive, AUDIT SELECT ON SCOTT.EMP; Or if you're only concerned about specific users, AUDIT SELECT TABLE BY SCOTT;
Now, the tricky business is that it appears that the exact SQL statement is not logged in the audit trail view, but STATEMENTID is which could prove useful on your quest.....

Regards, George Claborn (Oracle Server Development) Received on Fri Apr 11 1997 - 00:00:00 CDT