Re: Snooping the SQL issued by a client app

Figure out where the sqlnet.ora file on the client resides, and add:
trace_level_client = 16

You will end up with a huge trace file (sqlnet.trc) that will hold all traffic over the net.
The value 16 is equivalent to the string "support" (w/o quotes). Other values are 0 (== off), 4 (==user) and 8 (==admin)

You may want to experiment with lower values, as the size of the file will be enormous.

Another option would be to set tracing on the server, but that would trace all sql, not only yours.

hth,
Frank

CUJimmy wrote:

> I'm not a database/Oracle expert, but I have a custom 16-bit Windows
> program which extracts data from an Oracle 8i database (through SQL-
> net) to local files. It does this using embedded SQL and calls some
> stored procedures in the database.
>
> I need to find out what SQL it generates (directly or via stored
> procedures) while it runs, so I can ultimately figure out what it does
> and write an ODBC version of the same thing (unfortunately it has no
> docs or source code).
>
> Could someone tell me if there is a way to snoop the program in this
> manner? I'm hoping that there is some Oracle or SQL-Net mode, or other
> tool, which can dump the SQL sent from the client, or something like
> that.
>
> Thanks for any suggestions!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 20 2000 - 12:52:33 CDT