Use DBMS_SYSTEM.set_sql_trace_in_session to turn TRACE on for any users'
sessions. Then format the *.trc file with tkprof. This will collect the
SQL/DML statements as well as statistics for the statements.
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
George Miles <gmiles_at_eastman.com> wrote in article
<01bdab64$9ad6f560$8de288a8_at_PC83669134.kpt.emn.com>...
> I have been given the requirement of capturing the SQL statement for
SELECT
> access against a small set of tables by a small set of users. The
standard
> Oracle audit facility does not capture the SQL statement and triggers are
> useless for SELECTs (of course).
>
> Any suggestions?
> --
> George Miles
> Eastman Chemical Company
> gmiles_at_eastman.com
>
Received on Fri Jul 10 1998 - 00:00:00 CDT
