You can try Oracle Session Manager at http://www.wangz.net
to capture sql in realtime.
Forte Agent <1443131_at_usenetplanet.com> wrote in message news:<pfadru4mcp23u0evp9g8a776c4db8nonad_at_4ax.com>...
> Is there some way to capture SQL statements users execute using
> Oracle's generic AUDIT command? SYS.AUD$ table has STATEMENT column,
> but I do not know how that is used. I tried something like this:
>
> AUDIT SELECT ON xxx.yyyy BY ACCESS WHENEVER SUCCESSFUL;
>
> Looking at DBA_AUDIT_STATEMENT did not reveal anything. What to do??
> Thank you in advance.
Received on Sat Oct 26 2002 - 08:18:50 CDT
