Re: Help needed on Oracle traces

I believe in a previous post you asked assistance with a sqlnet trace. The information below is valid to obtain a sqlnet trace, and of course a sqlnet trace is a sqlnet trace.
To enable sql tracing either change the init<sid>.ora parameter to true and bounce the database or locate the sid and the serial# of the session and use dbms_system.set_trace_in_session(sid,serial#, true). The trace file will end up in the directory pointed to by your user_dump_dest parameter.

Hth,

Sybrand Bakker, Oracle DBA

<rangneka_at_my-deja.com> schreef in berichtnieuws 8hr5rm$58i$1_at_nnrp1.deja.com...
> 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