470,841 Members | 1,067 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,841 developers. It's quick & easy.

Running Oracle Trace

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.

Jul 19 '05 #1
1 5409
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.

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by kristoff plasun | last post: by
4 posts views Thread by BookerW | last post: by
1 post views Thread by =?Utf-8?B?Ym9va2VyQG1ndA==?= | last post: by
1 post views Thread by Terry Coccoli | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.