Re: Oracle SQL Tace tool

On Sat, 25 Apr 1998 17:50:44 -0500, "Guido Le Lorrain" <Guido_at_palmstech.com> wrote:

>Hello
>
>Has anyone out there heard of or is using an Oracle trace tool that will
>allow a developer to see what SQL statements are being executed. I am aware
>that some Oracle ODBC drivers do have a trace option but I'm not using ODBC.
>I'm actually using BDE native calls so I need a tool that actually captures
>the SQL statements passed to the Oracle database at the SQL Net level.
>
>I would be grateful for any sort help.
>
>Thanks
>
>Guido
>
>

On the client:

{SQL Trace version 2.x}
Remember to backup your existing copy of sqlnet.ora first!!

in the

%ORACLE_HOME%NETWORK/ADMIN directory:

in the SQLNET.ORA file add or modify the following entries :

        automatic_ipc          = OFF
        trace_unique_client    = ON
        trace_level_client     = 16
        trace_directory_client = [path]
        trace_file_client      = <filename>   <---- this is optional

where [path] is a valid directory for the trace files to be written to...
If you try to make this the ROOT directory of a disk drive, (drive X for example), you must enter
X:\. [note the period]
not simply
X:\ [no period]                                Received on Tue Apr 28 1998 - 07:03:45 CDT