Re: Help needed on Oracle traces

I'm afraid you won't find any sql-statements in a sqlnet trace file, but you can reduce output with "trace_level_client = user" (16=admin). Your statements can be found on the server, if you issue an activate trace (sqlplus: alter session set sql_trace = true; or by using the dbms_session package).

rangneka_at_my-deja.com wrote:
>
> Hello.
>
> I have editted my sqlnet.ora file in the following fashion to allow for
> tracing. (on the users machine)
>
> > trace_level_client = 16
> > trace_unique_client = true
> > trace_directory_client = <any existing directory>
>
> Unfortunately the trace file being returned is huge and contains info
> that I do not need at all. I was wondering there was anything else I
> have to add to the sqlnet.ora file in order to JUST bring back the SQL
> calls being passed to
> my server. I am connecting to the database using Crystal Reports via a
> native connection (ociw32.dll).
>
> Any help would be appreciated
> Shantanu
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jun 09 2000 - 00:00:00 CDT