Re: Capturing SQL for a specific user

On Tue, 29 Sep 1998 23:18:00 -0400, Ray Cruz <rcruz_at_totcon.com> wrote:

>Anyone know of a way to capture all SQL for a specific user? I realize
>that there is 3rd party software available to do this. However, my
>understanding is that this information can be pulled from the system
>tables. (BTW: I've looked at AUDIT and it doesen't seem to provide
>enough detail such as the actual SQL statement and the columns used for
>the "WHERE" condition).
>
>Can anyone help?

Use session-level tracing. Take a look at command "ALTER SESSION SET SQL_TRACE = TRUE/FALSE" for turning tracing for your current session on/off. For tracing someone else's session take a look at packaged procedure DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION. Tracing will collect all user's SQL and also the recursive SQL calls caused by them.

You can then dechipher the trace files with TKPROF utility to plain readable ascii files.
>
>Thanks!

HTH,

--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer