Re: Running Oracle Trace

From: AnaCDent <anacedent_at_hotmail.com>
Date: Mon, 12 Apr 2004 17:21:23 -0700
Message-ID: <6oGec.649$U83.555@fed1read03>

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 Mon Apr 12 2004 - 19:21:23 CDT