Running Oracle Trace

From: Terry Coccoli <request_at_ifneeded.com>
Date: Mon, 12 Apr 2004 17:49:50 GMT
Message-ID: <2FAec.12909206$Id.2153117_at_news.easynews.com>

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?

P.S. I reran the trace setting the TRACE_LEVEL_CLIENT to ADMIN, and that generated more data, but no visible SQL. Received on Mon Apr 12 2004 - 19:49:50 CEST

This message: [ Message body ]
Next message: Alex Ivascu: "Development Client"
Previous message: Mark D Powell: "Re: to check if a table exists"
Next in thread: AnaCDent: "Re: Running Oracle Trace"
Reply: AnaCDent: "Re: Running Oracle Trace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message