Re: Sniffing SQL on Client

Hi Steve,

You can trace whatever is sent to the server by adding a few lines to your sqlnet.ora file (for example c:\orawin95\network\admin\sqlnet.ora but it may be somewhere else)

TRACE_LEVEL_CLIENT = 16
TRACE_DIRECTORY_CLIENT = c:\temp
TRACE_FILE_CLIENT = bigtrace

The SQL (and everything else that goes to and fro the network layer for that matter so reserve some space)
is in the vertical collumns on the right

greetings

Harm ten Napel

Steve Mahoney wrote in message <3604F76C.11D4_at_bellatlantic.net>...
>Gang,
>
>We have an OCI-based application that uses SQL*NET 2.3 and runs under NT
>and 95. The problem we have is that we would like to be able to SNIFF
>the SQL on the client BEFORE it goes to the server.
>
>When this was a 16-bit app., we used a tool called SQL*INSPECTOR to do
>this but this tool has since been bought by a vendor and folded into a
>larfer tool set.
>
>I seem to recall that there is some "INTERNAL ORACLE" setting to do this
>for SQL*NET but cannot recall it.
>
>Does anyone know what this setting is?
>
>Thanks,
>Steve Mahoney
>Federated Investors
>412-288-8798
>smahoney_at_federatedinv.com
>
Received on Mon Sep 21 1998 - 15:44:15 CDT