Re: Help needed on Oracle Traces

<rangneka_at_my-deja.com> schreef in berichtnieuws 8ct52t$e4h$1_at_nnrp1.deja.com...
> Thanks, this worked like a charm.
>
> Do you know if it is possible to only output the actual SQL calls that
> are occurring? I get pages of data when I'm doing just a simple select.
>
> Regards,
> Shant
>
> In article <955128197.11792.3.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > trace_level_client = 16
> > trace_unique_client = true
> > trace_directory_client = <any existing directory>
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <rangneka_at_my-deja.com> wrote in message news:8ckuth$ql8
 $1_at_nnrp1.deja.com...
> > > Hello all.
> > >
> > > I was wondering if anyone could give me any info
> > > on what to change in the sqlnet.ora file in order
> > > to output a trace file when my application
> > > queries the Oracle database. I am using a native
> > > connection and thus using ociw32.dll to connect
> > > my app to Oracle.
> > >
> > > Any help would be appreciated.
> > >
> > > Thanks in advance,
> > > Shant
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Yes, but that would involve either tracing the session, or put the server in trace mode. To put the server in trace mode, add/change the line sql_trace = true
to init<sid>.ora.
Files will end up in the directory pointed to by user_dump_dest on the server.
The sqlnet trace provides some useful extra info, that can help you to identify unnecessary closing of cursors. You can identify this, if you see the same data being transmitted several times.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Apr 10 2000 - 00:00:00 CDT