Re: Running Oracle Trace

Terry Coccoli wrote:
> After opening up a ticket with a 3rd party vendor to find out what SQL
> they use behind the scenes, they advised and gave me instructions on
> running an Oracle trace.
>
> Basically, they told me to set TRACE_LEVEL_CLIENT to USER and to set the
> TRACE_DIRECTORY_CLIENT and TRACE_FILE_CLIENT parameters. I did, and the
> trace file gets generated, but I don't see any actual SQL calls.
>
> Am I missing anything else? Also, is there a good reference for running
> Oracle traces?
>
> Thanks.
>
>
> P.S. I reran the trace setting the TRACE_LEVEL_CLIENT to ADMIN, and that
> generated more data, but no visible SQL.
>

All you have done so far is trace traffic between the client & the DB server.

To actually see SQL go research how to set event 10046 on a "remote" session. Received on Tue Apr 13 2004 - 02:21:23 CEST