Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlnet trace in ProC app

Re: sqlnet trace in ProC app

From: Janey <janeyschrock_at_bigfoot.com>
Date: 2000/04/11
Message-ID: <38f379c0_2@news3.prserv.net>#1/1

I guess I did not make myself clear in my original post. I do not want an sql trace. I want a SQLNET trace. This is normally done by updating the sqlnet.ora file. We are having a network problem, and need to trace sqlnet. We have successfully traced sqlnet on the server and on the client using sqlplus. However, when we have the sqlnet.ora set for tracing and run our ProC application, no trace files are produced. So I was wondering if, for ProC apps, the sqlnet.ora is read at compile time vs. run time. Or if there is some precompiler option to turn on tracing. I have searched documentation on this issue and cannot find anything that says ProC apps are any different in this respect. I was wondering if anyone out there with real world experience has done this. Oracle says that for ProC apps, it is the same, it reads the sqlnet.ora at connect time. But then why am I having this problem? I have one sqlnet.ora file on my server that is acknowledged when I connect through sqlplus, but not when I connect through a ProC app. I think that the sqlnet.ora file is not being read when the ProC app connects. However, I don't know if it's not being read, because it can't be found (we've tried it in several places including setting TNS_ADMIN) or because the code simply isn't reading it.

Jane

Toby T. <eric_petersonNOerSPAM_at_maurices.inrg.com.invalid> wrote in message news:0ab30d68.9ed7d446_at_usw-ex0105-038.remarq.com...
> First of all, make sure that timed statistics are turned on in
> the database and run utlbstat. The reason why you want timed
> statistics on is when you tkprof the trace file, you will then
> get the time taken to execute, parse and fetch for each
> statement.
>
> Another way to turn on tracing in the program is the following
> statement after you log into the database:
> EXEC SQL EXECUTE IMMEDIATE 'alter session set sql_trace=TRUE';
>
> HTH
> Toby T.
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue Apr 11 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US